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.

We are having an issue with the SQL 2008 and SQL 2008 R2 servers in our environment.. While trying to log in using RDP.. the connection hangs on the 'Welcome' screen.. the server seems to be running alright and the databases can be accessed using SQL Management Studio.. but no one can log on the server.. Any thoughts??

share|improve this question
    
How do you know that this is a problem with SQL Server rather than Windows itself? –  Richard Feb 27 '11 at 12:06
    
Was this ever resolved? We're having the same issue. –  brian Jun 21 '11 at 12:50

3 Answers 3

If you have physical access, or kvm, check the console, barring that, try mstsc /admin; if that's no go, I would try running EventViewer on another computer in the same domain and connecting it to the server, something may be getting logged that will help.

share|improve this answer

Check out this url How to: View and Read SQL Server Setup Log Files and post back any errors you might find.

share|improve this answer

I assume you have tried multiple users logging in over RDP, eliminating a single corrupt user profile?

As mentioned in another answer, try logging onto the actual machine as opposed to over RDP to see if you can get in that way (try it with a local admin login too).

If you can get in on the console, try removing a user profile which is having problems logging on via RDP and try it again. I've seen the logon screen hang configuring Internet Explorer before (I'd just rebooted after installing IE8) and deleting the affected user profile folder did the trick.

share|improve this answer

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.