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.

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.

share|improve this question
    
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

1 Answer 1

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

ALTER LOGIN sa ENABLE;

(there may be a GUI equivalent too)

share|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

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.