Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version
Questions tagged [sql-server-2005]
1072 questions
0
votes
1 answer
Configuring SQL Server Express 2005
What's the proper way to configure SQL Server Express 2005 so that it can allow for a number of clients to get connected to the server? I have my application running both in the server machine and the client machines. Given the nature of my…
MrTognio
- 11
- 2
0
votes
1 answer
What are my SQL Server 2005 Disaster Recovery options if I can't have Enterprise edition?
We currently have a number of SQL Server 2005 Standard edition instances which support an intranet and need to be integrated into our disaster recovery plan. I was hoping to use database mirroring, on the grounds that the description of this on the…
Yellowfog
- 123
- 5
0
votes
1 answer
Need to Create Login for groups in SQL SERVER 2005
Can anyone help me on this regarding by providing the exact code?
I need to create two Logins named (Groups)
1. Dev_S
2. Dev_T
Each Group has exactly fifty (50) Users (as Dev_S1, Dev_S2, Dev_S3 so on) in it.
How can I add these 50…
Krish
- 1
0
votes
1 answer
Creating indexes on tables filled from transactional replication - SQL 2005
I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB with transactional replication.
The nature of the…
Will
- 408
- 3
- 8
0
votes
1 answer
advice on database index maintenance
I have a fairly large table, which I have to keep up, with some very, very fragmented indices. This seems to be causing problems with performance. I would like to have neat fresh crisp indices on this table. I also have some rather annoying…
Martijn
- 125
- 5
0
votes
1 answer
SSL Encryption with SQL Server 2005 Express not working as desired. No TLS/SSL protocol packets found
I'm trying to get SSL encryption working on SQL Server 2005 Express edition Svc Pk 3.
I've tried everything (worked the whole weekend), but I dont see TLS or SSL packets when I look at traffic using wireshark.
I have followed instructions on this…
FatherFigure
- 285
- 1
- 2
- 14
0
votes
4 answers
Shrinking Transaction log?
Why it is not recommended to shrink transaction log?
atricapilla
- 615
- 6
- 12
- 15
0
votes
2 answers
Securing MSSQL between two servers
I know MSSQL can have various login modes, windows only, windows + sql, etc. named pipes, tcp/ip.
Really I'm not sure what we should use. We have two servers each with IIS + MSSQL, network load balancing for IIS and DB mirroring for MSSQL.
Want to…
user59135
0
votes
1 answer
Connecting to MS SQL Server 2005 using FreeTDS on Mac OS X 10.6
I built freetds 0.82 from macports using the +mssql variant (which sets up dblib and sets the default tds version to 8.0). I am now trying to connect to my database server (MSSQL Server 2005) using tsql, but it only works when I override the tds…
Matt Campbell
- 183
- 5
0
votes
3 answers
SQL Server 2005 Performance
We have SQL Server 2005 SP3 Enterprise 32-bit running on a Windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE…
user489626
0
votes
1 answer
How do I connect remotely to SQL Server from Windows client?
Having a bit of an issue connecting to SQL SERVER remotely from Windows. I've verified that all of my settings are correct via SQL SERVER MANAGEMENT STUDIO EXPRESS and SQL SERVER CONFIGURATION MANAGER.
I can connect remotely using ODBC drivers from…
humble_coder
- 533
- 2
- 6
- 14
0
votes
2 answers
Job cannot be run because the SSIS subsystem failed to load. The job has been suspended
I am getting the following error when trying to run any of the Maintenance Task jobs that had been created on the server:
Message
[LOG] Step 1 of job 'Weekly Backup' (0x8EC76A988468C74897562440AADD067D) cannot be run because the SSIS subsystem…
Neil Fenwick
- 141
- 1
- 5
0
votes
2 answers
SQL Server problems
I have installed SQL Server 2005 but there is no server, I have reinstalled it about 5 times and the same problem never changes.
And here is the error message
Cannot connect to ..
ADDITIONAL INFORMATION:
A network-related or instance-specific
…
Omneya
0
votes
1 answer
Can not access SQL 2005?
the SQL has been installed but there is no server name and the Program does not accept any server name , and all the options , like the TCP , ports and Remote access are enabled
Omneya
0
votes
3 answers
Sql Server 2008 killed Sql server 2005
I have a windows server 2008 machine, which I had sql server 2005 running on happily, then I needed to install 2008 R2 for another job. I was hoping to run them side by side. I configured 2008 to run as SERVERNAME\SQLSERVER08 and 2005 is on…
Mark Milford
- 103
- 1
- 3