Login to SQL Express failed

by Mark 26. April 2011 10:13

Every few days our servers try to block our daily workflow with tricky errors or strange behavior.

Here a example from the evil SQL-Server express:

On of my colleagues run into this problem last week. He could not login into the Microsoft SQL Management Studio and the error message was:


He was logged in at one of our Servers with admin rights but the login didn’t work.

He logged in like


Then he asked me for a hint to this problem and I wondered why not simply put the servername instead the ip. if you logging in from a external source you have to use the ip if the service is running and the right ports are open.

So he tried


And voila, he got logged in… the day was saved.

But the battle between admin-good and server-evil will go on…




About the author

The authors are the admins at teamaton.

Isn't everyone a little admin?

Month List

Page List