When you work in distributed environment you probably use remote desktop session as you primary method of sql server machines administration. When critical windows updates are installed or when you install system or sql server service pack installation wizard prompts you to restart the box in order to complete the installation. And it happens from time to time that this machine hangs on reboot process for some reason and you can no longer connect it via remote desktop. If it was you local computer you could enter into your server room and press the reset button but if it stand thousands miles away from you it becomes a real problem.
How to restart or shutdown remote machine
If you can ping this machine from other computer and you have administrators rights on that machine you may use windows utility.
On a computer that has connection to the server which needs to be restarted or shutdown go to Start -> Run and type shutdown -i
This window will show up. Press Add and type either IP or DNS of remote server.
Select shutdown or restart and press OK. That 's it. For your convenience you may run from command line constant ping (ping server-name -t) when the server actually stopped to respond to ping's and when it started again.
Alternatively you can go to command prompt (start -> run -> cmd) on your workstation and Type
shutdown -r -m \\x.x.x.x
Replace x.x.x.x with the IP address or computer name of the remote machine. -r option is for restart, don't use -r if want to just shut down the system.
How to restart or shutdown remote machine
Moderator: sjj1805
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact: