Re: SQL Server registration failed because of the connection failure displayed below

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 07/24/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Wed, 24 Jul 2002 07:24:03 GMT

Hi Peter,

If I understand you correctly, please try the following steps to workaround
the problem.
1. Change the authentication mode from Windows to SQL Server on the
security tab in Properties window. There will be alert window to provide
you with two choices: Yes and No to re-start the server. Please click the
Yes button.
2. Right-click the server and select the 'Edit SQL Server registration
Properties' option. You also need change the authentication from Windows to
SQL Server there, and you should specify the login name and password.
3. Re-Start the SQL Server service.
4. You can try to connect to the server again.

If anything is unclear, please let me know.

Sincerely,

Linda Deng
Microsoft Support Engineer

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