Wednesday, 18 February 2009

SQL Server 2005 error 18452 'The user is not associated...'

If you are getting the above recorded in the logs try the following...

In SQL Server Management Studio, select security and change the system to use both Windows and SQL authentications.

You will need to restart the database service afterwards.