wom-worthly.com

Connection failed:

SQL Server Error: Error 18452

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘username’. Reason: Not associated with a trusted SQL Server connection.
SQL Server is not set to use both SQL Server and Windows Authentication Mode.

To resolve this issue, follow the instructions to set User Authentication.

SQL Server 2000:

1. Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
2. Right-click the Server name, select Properties > Security.
3. Under Authentication, select SQL Server and Windows.

SQL Server 2005:

1. Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
2. Right-click the Server name, select Properties > Security.
3. Under Server Authentication, select SQL Server and Windows Authentication Mode.

The server must be stopped and re-started before this will take effect

No related posts.

This entry was posted on Friday, November 7th, 2008 at 4:26 pm and is filed under Database, Software Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.