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:

2011-04-26_095552

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

He logged in like

2011-04-26_095712

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

2011-04-26_095645

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

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

Best

Mark

Tags:

About the author

The authors are the admins at teamaton.

Isn't everyone a little admin?

Month List

Page List