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.

First time I set up a SQL server, so I hope you can help me out.

I have a problem regarding logging in using SQL auth on my SQL EXPRESS 2008. I have added a user though the management interface as you can see on the image below.

alt text

But as soon as I try to login using SQL auth I get an error the login failed for the user. The server log says:

Login failed for user 'zebisgaard'. Reason: Could not find a login matching the name provided. [CLIENT: <named pipe>]
Error: 18456, Severity: 14, State: 5.

Do you have an idea why? I have triple checked that the username/password is correct, tried to recreate the user and so much more. And all this is localhost.

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

Sorry to ask, but are you REALLY sure that the username's correct? I only mention it because the login name in your screenshot is different from the one in the error message.

share|improve this answer
    
Oh...my....god.... I have been trying this for 3 hours soon. I can not believe I made this error so many times. Wow. It must still be weekend in my head. I apologize for my stupidity! –  meep Dec 2 '09 at 9:17
add comment

zebi z gaard is not the same as zebi s gaard.

share|improve this answer
add comment

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.