Wednesday 3 March 2010

Error 18452 (not associated with a trusted sql server connection)


If you've received this error, it maybe trivial to think the user doesn't have permissions to access SQL Server. For me, I didnt have 'Mixed Mode Authentication' enabled the first time and this time, I forgot to restart the SQLServer Windows Service (in configuration manager)..

Heres an overview...

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

SQL Server 2000:

Go to Start > Programs > Microsoft SQL Server > Enterprise Manager
Right-click the Server name, select Properties > Security
Under Authentication, select SQL Server and Windows
The server must be stopped and re-started before this will take effect


SQL Server 2005:

Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode
The server must be stopped and re-started before this will take effect..."

http://www-1.ibm.com/support/docview.wss?uid=swg21119906

It has solved my problem, so I hope it could be helpful for you too.

No comments: