sql server connect: I am running Sql Server 7 on a windows 2000 professional
machine at service pack 4. I am getting the error as
follows.

Connection failed:
SQlState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen (gethostbyname()()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General
network error. Check your network documentation.

Any ideas on why this is happening or how to fix it would
be appreciated.

The key to this error is the OS Error 11001. This is a Winsock error,
which indicates the client machine can't resolve the remote host name.
Work with your network staff to resolve the problem you're having with DNS.

Run the following commands:

ipconfig / flushdns
ipconfig /registerdns

Then try connecting again. If you're still receiving 11001, you should
make a network trace and review it with the networking staff.


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.