Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 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! – janhartmann Dec 2 '09 at 9:17

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

share|improve this answer

Your Answer


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.