June 20, 2013 at 12:46 pm
Hi,
My Server has installed with SQL 2000 and iam trying to connect to SQL Server through ODBC and iam getting the following error
Connection Failed:
SQL STATE: '01000'
Server Error: '10060'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectOpen
(Connect())
Connection failed:
SQLState: '08001'
SQL Server Error: 17
From the same network iam able to connect from another system. Both the systems are Windows 7 64 bit
Can some one help me to sort this out. Awaiting for some solution. Thanks in advance.
September 1, 2013 at 2:51 pm
Hello,
A first remark : SQL Server 2000 is no longer supported ( even in extended support ).The same thing is occurring shortly for SQL Server 2005 ( all SP ). It would be useful to upgrade your SQL Server towards SQL Server 2008 R2 ( the direct jump to SQL Server 2012 is impossible ).
Usually , when I have a problem of connection to a SQL Server , I am searching the answer in the SQL Server Protocols Blog
http://blogs.msdn.com/b/sql_protocols/ where I find quickly a solution to my problem.
But you are using SQL Server 2000 and I have noticed a little sentence which could make more difficult to find the solution
"One of the more visible changes we made in connectivity space for SQL Server 2005 was enhancing error messages reported to the user in case of connection failures"
- SQL Browser is not existing before SQL Server 2005 which makes less easy the remote connections
see http://blogs.msdn.com/b/sql_protocols/archive/2005/09/22/473111.aspx and
http://blogs.msdn.com/b/sql_protocols/archive/2005/09/22/473111.aspx
http://blogs.msdn.com/b/sql_protocols/archive/2005/09/28/474698.aspx
Some useful links :
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Even if these articles were written for SQL Server 2005 and over , some ideas they provided could be useful for you
A last thing : which is the last service pack installed on your SQL Server ? Which is the edition also ?
Have a nice day
September 1, 2013 at 3:08 pm
Hello ,
Have you read this thread ?
http://www.sqlservercentral.com/Forums/Topic780491-9-1.aspx
Have a nice day
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply