SQL – ot associated with a trusted SQL Server connection

Published by

Posted on March 26, 2008

A SQL Server login

Use a valid Windows login to connect to SQL Server. If you must continue to use a SQL Server login, you can change the security authentication mode in SQL Server to SQL Server and Windows. To do this, follow these steps:

1. Start Enterprise Manager.
2. Expand Microsoft SQL Servers, and then expand SQL Server Group.
3. Right-click the server that you want to change to SQL Server and Windows authentication, and then click Properties.
4. In the SQL Server Properties dialog box, click the Security tab, click SQL Server and Windows, and then click OK.
5. When you are prompted to re-start the SQL Server service, click Yes.

Note If you use SQL Server 2005, use SQL Server Management Studio instead of Enterprise Manager to change the security authentication mode.

reference:  http://support.microsoft.com/kb/889615

on SQL 2005 server : check the authentication mode