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

The server authentication is set to:

SQL Server and Windows Authentication mode

I can connect using Window authentication but not SQL authentication.

Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)

Error Number: 18456
Severity: 14
State: 1

I have reset the sa password and started and stopped the serveries to no avail.

I also created a new login. No dice.

UPDATE:

There as a process on another computer that was stuck in a loop. Once I killed the process I was able to login. I don't know why or how. But that is one only thing that I know of that changed.

link|improve this question
69% accept rate
Please post your update as an "answer" - you will then be able to select that as the "correct" answer to the question, so that it can help others who may come along in the future with the same issue. – Mark Henderson♦ Feb 12 '11 at 20:16
@Mark Henderson -- I don't believe the update to be an acceptable answer. Having a stuck process on another computer doesn't explain why just the SQL authentication quit working. If someone could correlate the two that would be an answer. IMHO – NitroxDM Feb 14 '11 at 16:51
feedback

1 Answer

up vote 0 down vote

IIRC you need to enable the account as well as set the password:

ALTER LOGIN sa ENABLE;

(there may be a GUI equivalent too)

link|improve this answer
Been there done that. ALTER LOGIN [sa] WITH PASSWORD='newpassword', CHECK_POLICY=OFF GO ALTER LOGIN [sa] ENABLE GO – NitroxDM Feb 12 '11 at 19:00
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.