up vote 0 down vote favorite
share [g+] share [fb]

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
------------------------------
link|improve this question
100% accept rate
feedback

2 Answers

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.

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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