If you try to connect from Query Analyzer, the error message that occurs is:
- 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-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.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
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:
Article ID: 316779 - Last Review: Sep 12, 2008 - Revision: 1