SQL – ot associated with a trusted SQL Server connection
Published by exdone
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
- An error has occurred, which probably means the feed is down. Try again later.