Hi,
I hope someone can help me out here? I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS.
I am getting the following error message:
Connection failed:
SQL State :'01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).
Connection Failed:
SQL State :'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
From support.microsft.com I have tried changing the TCPPort value to 0, but this has not helped. Does anyone have any further ideas please?
Jackie
Which protocols are enabled? Have you tried running cliconfg.exe?|||Hi Anton,
I have looked at cliconfg.exe and have enabled TCP/IP and named pipes for genera connections. Both were already enabled for connections to this SQL Server installation.
Another thought is that the connection works top a server running SQL Server 2k sp 3a, but not to this server running SQL Server 2k sp4. Perhaps I should just reinstall and put sp3a on instead?
Jackie
|||Have you already exhausted all the possibilities mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1sql
No comments:
Post a Comment