I cannot log in with sa user (error 18452)

Hi to all.

I'm trying to log in on local machine to my SQL Server 2005 (in Windows Server 2003) using a user not trused, like as 'sa' user, but I receive the error Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).

No problem to connect with trusted user (my logon user to operating system).

I set the auth mode to SQL Server & Windows but doesn't work.

What can I do?

Ciao.

Hi,

you did either not set Mixed Authentication for the instance you are connecting, or you are connecting to the wrong instance or you did not restart the service after changing the authentication mode. The is no other explanation for this error message.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I've seen people get this error when trying to work out what authentication mode they want. They switch from one to the other, but don't restart the service - only to find that the mode hasn't actually changed yet.

Rob