remotely start/stop sql server service in a workgroup

20 Jan 2006 8:38 PM

Fred

hi, i have an administrator account on a box, there is a sql server pc
in the same workgroup w/ a different admin pass (which i know ^_^, and
the sql sa pass too), how can i restart the sql server service from my box ?

20 Jan 2006 9:43 PM

Anith Sen

You can use xp_cmdshell with NET START/STOP MSSQLSERVER command. On you
command prompt type in NET START /? for details on this DOS command. For
details on xp_cmdshell, refer to SQL Server Books Online.

--
Anith

21 Jan 2006 2:33 AM

Fred

Anith Sen wrote:

> You can use xp_cmdshell with NET START/STOP MSSQLSERVER command. On you
> command prompt type in NET START /? for details on this DOS command. For
> details on xp_cmdshell, refer to SQL Server Books Online.
>

xp_cmdshell is deleted(as recomended by every sql server security
quide), i can kill the process using pskill, but could that lead to data
loss?

21 Jan 2006 9:55 AM

Tibor Karaszi

You can stop using the TSQL SHUTDOWN command.

At the OS level, you can both start and stop using NETSVC.EXE (Google for it).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Fred" <fred@ilovespam.com> wrote in message news:exFBLGgHGHA.2036@TK2MSFTNGP14.phx.gbl...
> hi, i have an administrator account on a box, there is a sql server pc
> in the same workgroup w/ a different admin pass (which i know ^_^, and
> the sql sa pass too), how can i restart the sql server service from my box ?