I've got a Windows 2003 server that's at my remote data center. This morning I tried to connect to it via RDP, but the connection fails with the following error:
This computer can't connect to the remote computer. Try connecting again. If the problem continues, contact the owner of the remote computer or your network administrator.
I have also trying issuing a remote shutdown/restart command using the "shutdown -i" command from my local system. No error is reported, however the system does not reboot.
This server runs SQL Server 2005 and it is still fully operational and responsive to queries.
I can also remotely connect to the services control panel of the remote system.
Is there anything that I can try to regain control of the system, short of having an operator in the data center do a hard reboot on the server for me?
I encountered the same issue trying to perform a remote reboot on a Windows XP machine. What I ended up doing was using the PsKill command, part of the SysInternals PsTools suite, to kill the Winlogon process, like so:
This will cause the remote machine to reboot immediately.
Try instead:
That's a bit drastic, but I've had the need to do that in a very similar environment to what you describe. I also open a cmd window and start a ping -t against the server to watch when the IP stack goes down and comes back up. This is a very useful indicator of activity when you don't have physical access to the server (or are too lazy to get up and walk over to it).
EDIT: (based on your comment) Ok, do this first and then try the above again (or restart it as normal if this works). See it that gets you farther. The -a will abort a system shutdown.
Well, this is kind of crazy but you can enable xp_cmdshell on SQL Server then execute commands as the user that is running SQL Server, so you can do a shutdown -r if it won't listen to remote commands.
If you want to try and re-start RDP w/o rebooting the box, you may try (this is untested; I'm not going to do this on any of my boxes :D):
Figure out what is listening on 3389 (RDP port) by asking for:
Kill the pid with taskkill. Finally, issue a
Hold your breath, then try RDP again.
If you issued a shutdown/restart and the server just will not go down, you can kill the wininit.exe process with the pskill tool. In windows 2012, you can use taskkill native tool.
First check to always do whether you're sure of it, check if firewall let RDP go through ;) That's not stupid, It's just sometime happen out from nowhere ;)
Also check that Terminal Service is on, and maybe try to reboot it if you have a chance to get physically on the server.
This kind of thing also happen to me on my 2003 R2 server.
When Terminal Services stops working.
This is less an answer to your question and more an explanation to what might have caused it. I have seen RDP stop working several times on Windows Server 2003, and it's usually occurs in one of two scenarios;
Post-patching. The system is restarting after an automatic update, but never fully shuts down. Terminal sessions are logged off and no new connections are accepted, but the server (file, mssql, DC) keeps on working.
This KB article CTX116901 describes a fault where the session image space is too small and it can't load any more video or printer drivers, (hence it being a problem for MetaFrame servers).
To set the size of the session image space via registry key, try
Try values like,
0x10 (16 Mb)
0x20 (32 Mb)
I had same problem the PSKill worked like a charm - have looked for at program like this for ages - never knew that sysinternals had released one.
this is usually caused by a task that will not shut down, the server awaits the task shutdown in order to continue with the restart. you can solve this by finding the culprit task and remotely closing it. use: tasklist /s HostName usually SQL is the immediate suspect. use Taskkill to kill it, and the server will than carry on with the restart.