December 19, 2011 at 8:28 am
Hi All,
I am unable to connect to one of my production sql server using RDP(remote desktop connection).
server team have decided to reboot the server for fixing the issue.
I want to stop my all services in server before going to reboot..
So how can i stop the services as i am unable to connect to server..
Thanks .
December 19, 2011 at 9:27 am
Do you have a connection to the server in any way? If you can connect as an admin, you can do a NET STOP on that machine's services.
December 19, 2011 at 9:28 am
Just wondering, when they will reboot the server,
all the sql services will automatically be stopped and restarted...
Why you need to manually stop the services first then .?
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
December 19, 2011 at 11:42 am
You may be able to use the sc command.
December 20, 2011 at 3:49 am
SKYBVI (12/19/2011)
Just wondering, when they will reboot the server,all the sql services will automatically be stopped and restarted...
Why you need to manually stop the services first then .?
Regards,
Skybvi
Stopped or Killed (must be avoided).
December 20, 2011 at 3:59 am
geetha@in (12/19/2011)
I am unable to connect to one of my production sql server using RDP(remote desktop connection).
1) Why do you want to RDP to this server?
2) What is the errror message?
December 20, 2011 at 5:56 am
geetha@in (12/19/2011)
I want to stop my all services in server before going to reboot..
Why you want to stop the services?
(i assume all are set with "Automatic" option.they will get automatically up and if they are with "manual" option then u have to do it manually). there is no point to stop them before shutting/restarting machines.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 8:01 am
Hi..Thanks to all for giving your inputs.
I believed that all sql server services will automatically stopped and restarted in the time of rebooting..But i don't know in our team everytime we stopped the services and informed to server team and they will do reboot the server (especially for patching the servers or fixing the some connection issues like RDP)
coming to RDP issue I can't connect to the server as admin since i don't have admin privilege to that server.when i connect to server i got the be below error message
"remote connections might not be enabled or the computer might be too busy to accept new connections or network connection problem"
So the person under the server team was tried "net stop and net start "commands for fixing the connection issue..But still the same.
Any way server team finally decided to reboot the server after business hours.
As i am new to the DBA i don't know much about all.I have been started to learn ..
Thanks
Geetha
December 20, 2011 at 9:20 am
When someone reboots a server, it sends a "stop" message to all services. They aren't killed, they are shut down. It's possible that someone might kill the SQL Server service if there is a large rollback, but it will maintain integrity.
If you don't have admin privileges for RDP access, you probably don't have access to start/stop services either.
December 21, 2011 at 3:14 am
I would ask, though--why do you need to RDP to the server? Most of the work you should ever need to do in SQL server can be done via SQL Management Studio from your own machine. RDPing to the server isn't going to help you if you don't have admin rights anyway, so you might as well connect remotely.
December 21, 2011 at 3:54 pm
To stop services remotely open the services.msc on your machine. In the top left of the services console where you see "Services (local)", right click and select "connect to another computer". Supply the remote computer name and select "OK". If you have the appropriate permissions on the remote computer, you will be able to remotely start\stop the services.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2011 at 6:23 am
Perry Whittle (12/21/2011)
To stop services remotely open the services.msc on your machine. In the top left of the services console where you see "Services (local)", right click and select "connect to another computer". Supply the remote computer name and select "OK". If you have the appropriate permissions on the remote computer, you will be able to remotely start\stop the services.
Perfect
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
December 22, 2011 at 7:25 am
If you are in the SQL Server sysadmin server role, you can issue the following command from a query window to stop the SQL Server service. It will also stop the SQL Agent service, since that depends on the SQL Server service.
shutdown with nowait
Note that if SQL Server is on a cluster, it will probably cause a failover to another node, and SQL Server will restart on that node, depending on how the cluster is configured. On a cluster, the best option is to set SQL Server offline using the cluster administrator.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply