eneral network error. Check your network documenta

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 2005 Forums

Other SQL Server Topics (2005)

eneral network error. Check your network documenta

Author

Topic

yupsay
Starting Member

5 Posts

Posted - 2009-12-22 : 22:56:56

While connecting to multiple SQL Servers & retrive size/space information for all the DB's there. The following error pops up on two of SQL 2005 (patched 4207) named instances.

Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

Looking at the forums I'm seeing the following as solution.
1. NIC update
2. NAV uninstalled
3. Reg edits
4. Server config changes

Now my script is running from one host & fails from another which are at seperate geographical locations. Second the script runs for a few databases & then fails so belive I've something worng the ADO objects / connection pooling in here.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-22 : 23:23:09

Try connecting to the database server via HostName,PortNumber. If that doesn't work, try telnetting to it: telnet hostname portnumber. If that doesn't work,t hen you'll need to talk with your network admins since it's a network problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources