How to remotely start SQL server on other box.
Thanks for help.
-Tomdepend on how you connect to the remote server:
1. Connect to remote server using SERVICES.MSC and start SQL services
2. Connect to remote server using SQL Server Service Manager and start SQL
services
3. Connect to remote server using Terminal Services and start SQL services
........................
"Tom Torain" <anonymous@.discussions.microsoft.com> wrote in message
news:de6101c3f006$5386a970$a001280a@.phx.gbl...
> How to remotely start SQL server on other box.
> Thanks for help.
> -Tom|||can also use the netsvc.exe reskit utility /start option to start MSSQLServe
r service programatically|||Thanks for help.
I like to use command prompt to start remote SQL Serber
2000. Any way to do it?
-Tom
>--Original Message--
>depend on how you connect to the remote server:
>1. Connect to remote server using SERVICES.MSC and start
SQL services
>2. Connect to remote server using SQL Server Service
Manager and start SQL
>services
>3. Connect to remote server using Terminal Services and
start SQL services
>........................
>
>"Tom Torain" <anonymous@.discussions.microsoft.com> wrote
in message
>news:de6101c3f006$5386a970$a001280a@.phx.gbl...
>
>.
>|||Use the regkit command sc
sc //server start mssqlserver
<anonymous@.discussions.microsoft.com> wrote in message
news:e3f801c3f00d$46619ff0$a601280a@.phx.gbl...
> Thanks for help.
> I like to use command prompt to start remote SQL Serber
> 2000. Any way to do it?
> -Tom
>
> SQL services
> Manager and start SQL
> start SQL services
> in message|||Look at the SC command. Built-in on 2003 and XP. Resource kit load on
Windows 2000.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:e3f801c3f00d$46619ff0$a601280a@.phx.gbl...
> Thanks for help.
> I like to use command prompt to start remote SQL Serber
> 2000. Any way to do it?
> -Tom
>
> SQL services
> Manager and start SQL
> start SQL services
> in message|||Thanks to all of you.
SC command works great!
-Tom
>--Original Message--
>Look at the SC command. Built-in on 2003 and XP.
Resource kit load on
>Windows 2000.
>
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
><anonymous@.discussions.microsoft.com> wrote in message
>news:e3f801c3f00d$46619ff0$a601280a@.phx.gbl...
start
wrote
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment