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

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


From: lideng@online.microsoft.com (linda deng[MS])
Date: Thu, 25 Jul 2002 04:47:12 GMT


Hi Peter,

Since you have configured the authentication mode as 'SQL Server and
Windows' authentication in the security tab, you should also set it in the
'Edit SQL Server registration Properties' window. Once you have chosen the
'Use SQL Server authentication' option, the 'Login Name' and 'password'
will be enabled. You should specify the account and password there, which
is the standard account of the SQL Server like 'sa' and others created as
'SQL Server Authentication' in the Enterprise Manager (EM). They are
different from the Windows account, for example, 'SPECIALTY\pafo' and
'Administrator'. You can try to add a new login by expanding
security\logins in EM.

The authentication mode 'SQL Server and Windows' support two authentication
methods. You can specify the standard account after selecting 'SQL Server
authentication'. Or, you can select 'Windows authentication' which doesn't
require you to specify the account, because it authenticates with the
account which you login on the operating system.

If you have any further questions, please don't hesitate to contact me.

Sincerely,

Linda Deng
Microsoft Support Engineer

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