BUG: "Unable to Connect" Msg May Occur in Application Event Log (167352)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q167352
BUG #: 15849 (Windows: 6.5)
SYMPTOMS
Under certain situations, one of the following errors may be logged by SQL
Server in the Application Event Log:
Severity: 9 Error:10004, OS: 11001 Unable to connect: SQL Server is
unavailable or does not exist.
General network error. Check your documentation.ConnectionOpen
(gethostbyname()()).
Severity: 9 Error:10004, OS: 252 Unable to connect: SQL Server is
unavailable or does not exist.
General network error. Check your documentation.ConnectionOpen
(ReadPropertyValue()).
Similar messages may also appear, depending on which Net-Library you have
set as the default.
CAUSE
By default, the xp_sqlregister extended stored procedure is run
automatically at SQL Server startup. If the default client Net-Library on
the server is set to non-named pipes IPCs such as TCP/IP or IPX/SPX, you
would see this error message in the Windows NT Server Event Viewer. This
error message occurs when this particular extended stored procedure tries
to log on to SQL Server using dot "." as the local server name. This fails
because dot "." is not valid as the local server name under non-named pipes
IPCs.
WORKAROUND
While on the server, use the SQL Server Client Configuration Utility to change the default Net-Library back to Named Pipes. Since the setting of a default client Net-Library on the server does not affect how other clients connect to SQL Server, you should never have to set the default Net-Library on the server to anything other than named pipes. If you need to connect to other SQL Servers from this server using non-named pipes IPCs, you can always do so through advanced entries in the client configuration. For more details, see the SQL Server the Books Online.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5.
| Modification Type: | Minor | Last Reviewed: | 2/22/2005 |
|---|
| Keywords: | kbBug kbenv KB167352 |
|---|
|