Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Sql server is in Mixed Mode and I changed the user Password through Windows Authentication Mode from Security. After that when I try to connect the server it throw the error

TITLE: Connect to Server
------------------------------

Cannot connect to AZHAR\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
share|improve this question
up vote 3 down vote accepted

This error message is thrown then the SQL Server is running on WINDOWS AUTHENTICATION mode. Please change it back to Mixed mode and you will be able to login using SA account.

share|improve this answer
    
but how or from where to change to Mixed mode??? – Azhar Sep 2 '10 at 6:30
    
Open SSMS. Right click on the Instance Name --> Properties --> Security. Select "SQL Server and Windows authentication mode". Click Ok. Restart the instance – Pradeep Adiga Nov 8 '10 at 9:14

My SQL server is of SQL 2005 version and in Mixed authentication mode.Still I got the above error for a windows login. Restarted SQL services and then conenction was successful.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.