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.

I installed SQL Server 2008. During the install I set it to mixed mode authentication and set the password for what I assume is the sa account. In the configuration manager I set tcp/ip and named pipes to enabled.

When I open SQL Server Management Studio and try to log in - username: sa, password: whatIjustsetintheinstall, it fails with the error:

Login failed for user sa. (error 18456). The error in Event Viewer is - Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>].

I know the password is right because I just set it. What am I doing wrong here? Is sa not the right user to be logging in with mixed mode? I've been reading through forum after forum but just cannot find anything that works.

share|improve this question
add comment

migrated from stackoverflow.com Nov 20 '11 at 1:07

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote accepted

[This will soon get migrated to ServerFault but...]

It's entirely possible you mistyped the password twice for the sa account on install. I've done it. Try to log in with Windows Authentication to see if you can reset the sa password. If not, you will either have to hack your install or reinstall.

share|improve this answer
    
This is super dumb, but I tried sa with no password and that worked. I'm just going to write this off as "it's been a long day" and stop trying to understand. Thanks for your help! –  tessa Oct 13 '11 at 22:24
add comment

Your Answer

 
discard

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