<div>
Terminal service into the server and start the service.
</div>


Terminal service into the server and start the service.

<div>
<br />
<br />
net start mssqlserver<br />
net start sqlserveragent<br />
<br />
to shut it down<br />
<br />
net stop sqlserveragent /y<br />
net stop mssqlserver /y<br />
<br />

</div>




net start mssqlserver
net start sqlserveragent

to shut it down

net stop sqlserveragent /y
net stop mssqlserver /y



<div>
That only works on the local machine.....<br />
<br />
You could also build a proc using sp_OA to use the SQLDMO to autostart the remote server just like Enterprise Manger does--(or create a vbscript file like this):<br />
<br />
Set myserver=CreateObject(&quot;SQL<wbr />DMO.SQLSer<wbr />ver&quot;)<br />
myserver.Name = &quot;JAS1&quot;<br />
myserver.Login = &quot;sa&quot;<br />
myserver.Password=&quot;sa&quot;<br />
myserver.LoginTimeout = 5<br />
myserver.LoginSecure = False<br />
<br />
If myserver.Status&lt;&gt;1 Then<br />
&nbsp; &nbsp; myserver.Start(True)<br />
End If<br />

</div>


That only works on the local machine.....

You could also build a proc using sp_OA to use the SQLDMO to autostart the remote server just like Enterprise Manger does--(or create a vbscript file like this):

Set myserver=CreateObject("SQLDMO.SQLServer")
myserver.Name = "JAS1"
myserver.Login = "sa"
myserver.Password="sa"
myserver.LoginTimeout = 5
myserver.LoginSecure = False

If myserver.Status<>1 Then
    myserver.Start(True)
End If


<div>
If you are using SQL-2000 , and have W2000 installed and pre-authenticated on the network, &nbsp;you could look at using the MMC Console......
</div>


If you are using SQL-2000 , and have W2000 installed and pre-authenticated on the network,  you could look at using the MMC Console......

<div>
<div class="content wysiwyg-content">
Searched in Google... No use...<br />
<br />
Back to pavilion...<br />
<br />
Does anyone know how to start the SQL Server service of a remote server from any workstation's command prompt?<br />
<br />
Any other alternatives...<br />
<br />
Thanks in advance...<br />
<br />
Cheers,<br />
<br />
Rajesh
</div>
</div>


Searched in Google... No use...

Back to pavilion...

Does anyone know how to start the SQL Server service of a remote server from any workstation's command prompt?

Any other alternatives...

Thanks in advance...

Cheers,

Rajesh

How to start the SQL Server service of a remote server from any workstation's command prompt?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.