Article ID: 316779
Article Last Modified on 6/13/2003
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q316779
SYMPTOMS
Clients that have the Force Protocol Encryption option set ON on the client may fail to connect to SQL Server if clients specify an IP address for the server name.
If you try to connect from Query Analyzer, the error message that occurs is:
If you try to register the server from the SQL Enterprise Manager, the error message that occurs is:
WORKAROUND
To work around this problem, you can use either of these methods:
- Use the server name to connect to SQL Server. You can use the SQL Server Client Network Utility to set up an alias for the server that is running SQL Server or implement name resolution by using WINS, DNS, or LMHOST file so that you can connect by server name.
-or-
- -or-Set the Force Protocol Encryption option to ON on the server by using the SQL Server Server Network Utility. If you turn on encryption on the server, all the clients must connect by using encryption and you must install a certificate on the server. For more information, refer to the "Net-Library Encryption" topic in SQL Server 2000 Books Online.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
318605 INF: How SQL Server Uses a Certificate When the Force Protocol Encryption Option is Set On
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
MORE INFORMATION
You turn on the Force Protocol Encryption option by using the SQL Server Client Network utility.
For additional information about how to configure SQL Server to use certificates, click the article number below to view the article in the Microsoft Knowledge Base:
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
If a client fails to connect to SQL Server and this error message occurs
you need to make sure that SQL Server is restarted after the certificate is installed on the server that is running SQL Server.
Additional query words: encryption certificate SSL Secure Sockets Library
Keywords: kbprb KB316779