Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smemflynn
Starting Member
10 Posts |
 Posted - 2008-03-13 : 06:17:26
|
| Hi,If someone can help me with this I'd really appreciate it!I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling the instance servername\databasename which is annoying as I can’t change it now. Anyway, I created a database and overwrote it with a copy from our live machine. All looking good, I then couldn’t connect via ODBC from my client PC (XPSP2). I was getting the error:Connection Failed:SQLState:‘01000’SQL Server Error: 53[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(Connect()).Connection Failed:SQLState: ‘08001’SQL Server Error: 17[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.I mirrored the exact settings that were in the Client and Server Network Utility consoles on the 2000 server, but I still couldn’t connect. (The settings on the Windows 2000 machine were all defaulted). I tried a myriad of combinations of settings on the server machine, and in the client configuration utility of my xp machine, but to no avail. I tried to follow a couple of online postings I found, but I really just ended up confusing myself further.. THEN, I remembered I never installed the service pack… soo I installed SP4, and after a reboot, SQL Server failed to start, so I started it manually. Then I noticed SQL agent hadn’t started so I tried to start it but it refusing to start. I’ve rebooted twice and still I’m getting the same result.I am also getting the following three errors in event log (I’ll start with the first one entered):Source:MSSQL$DatabaseCategory: [2]EventID: 17052Description:Error 17882, Severity: 18, State: 1Error accepting connection request via Net-Library ‘SSNETLIB’. Execution continuing.-----------------------------------------------------------------------------------------------------------Source:MSSQL$DatabaseCategory: [2]EventID: 17052Description:Error 17882, Severity: 18, State: 0Operating system error 53: The network path was not found.________________________________________________________________________Source:MSSQL$DatabaseCategory: [2]EventID: 17052Description:Error 17882, Severity: 18, State: 0No longer waiting for client connections using Net-Library’SSNETLIB’Is this a righteous mess up? Will I have to reinstall? As everything looked okay on the server before I tried the ODBC, SQL dependent front end applications that are very configuration heavy have been installed and I’m afraid a SQL reinstall might mess things up Any help I would most appreciate it!Thanks-Emily |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-13 : 23:26:17
|
| Did you enable named pipes and/or tcp/ip on the server? Did you specify servername\databasename as server name in dsn? |
 |
|
|
smemflynn
Starting Member
10 Posts |
Posted - 2008-03-21 : 05:48:20
|
| Hi,My apologies for the late delays in answering. Yes, I tried a variety of combinations of TCP and pipe name settings (there's quite a lot of conflicting articles on line), but I still couldn't get it to work. So I reinstalled a default installation, applied SP4 straight away and I connected via ODBC first time. Everything is working hunky dory now except for a problem I'm having creating a database from a backup, but that's a different issue altogether and I will be posting about it shortly!ThanksEmily |
|
|
|
|
|
|
|
|
ODBC connectivity and SP4 issue