Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

Have you restarted the instance since you changed the authentication from Windows Only to Mixed?

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.