BUG: Cannot Connect to a Clustered Named Instance Through a Firewall (318432)
The information in this article applies to:
- Microsoft SQL Server 2000 Enterprise Edition
This article was previously published under Q318432
BUG #: 356696 (SHILOH_BUGS)
SYMPTOMS
If you try to connect a clustered named instance of SQL Server through a firewall, and you use only the instance name (for example, SQL_Virtual_Name\Instance_Name) in the connection string, the connection fails and you may receive one of the following error messages:
Specified SQL server not found.
SQL Server does not exist or access denied.
If you run a network trace on the server, you can see that the server actually receives the query from the client computer on UDP port 1434 for the virtual server IP address; however, the answer is sent with the physical IP address of the cluster node that is currently running SQL Server.
CAUSE
When a client computer connects to a computer that is running a clustered instance SQL Server, if the connection string does not specify the destination TCP port, the client library queries the server on port UDP 1434 to collect information about the instance.
When the server returns the information, the network frame contains the IP address of the physical node instead of the IP address of the virtual server. Depending on the firewall configuration, this network packet may be dropped, and the client may not receive any answer.
WORKAROUND
To work around this behavior you can either:
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/10/2002 |
---|
Keywords: | kbbug KB318432 |
---|
|