SQL Server TCP/IP connection errors

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server TCP/IP connection errors

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-30 : 07:23:42

David writes "I am having an intermitent problem remotely connecting to a SQL 2000 SP3 machine. I am getting the following error messages:

9/30/2003	10:17:07 AM VBRuntime Error None 1 N/A US006513 

The VB Application identified by the event source logged this 

Application Process Scheduler: Thread ID: 9000 ,Logged: 6001 - 

ActiveBatchStamper- ProcessDiffDateTimeStamp - 



vbError #  40002-01000: [Microsoft][ODBC SQL Server Driver]

[TCP/IP Sockets]ConnectionOpen (connect()).

rdoError #  10060-01000: [Microsoft][ODBC SQL Server Driver]

[TCP/IP Sockets]ConnectionOpen (connect()).

rdoError #  17-08001: [Microsoft][ODBC SQL Server Driver]

[TCP/IP Sockets]SQL Server does not exist or access denied.

Does anyone have any idea what might be causing this issue?"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-30 : 12:32:48

Is SQL Server not listening on 1433? Is it a named instance? If either of them is yes, then you'll need to create an alias on the client so that it knows how to connect to the SQL Server. An alias is created using Client Network Utility. If you don't have that tool, you can add one via the registry. Search the forums for alias and Client\ConnectTo.

Tara

stephe40
Posting Yak Master

218 Posts

Posted - 2004-01-30 : 16:11:27

Can you connect to the sql server with the QA? If not, try updating the MDAC compoenents. You can download them from www.microsoft.com/data

- Eric

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources