How to remotely start SQL Server instance?

When you connect to SQL Server instance using SQL Query Analyser there is
"Start SQL Server if it is stopped" option. Is it possible to remotely
start stopped SQL Server instance from my custom application? How?You can use DMO, SMO, or WMI to remotely start the service, google for
more information on this topics like here:
http://www.devx.com/vb2themax/Tip/18459
HTH, Jens Suessmeyer.

How to remotely start SQL server

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 MSSQLServer 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...
>> How to remotely start SQL server on other box.
>> Thanks for help.
>> -Tom
>
>.
>|||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
> >--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...
> >> How to remotely start SQL server on other box.
> >> Thanks for help.
> >>
> >> -Tom
> >
> >
> >.
> >|||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
> >--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...
> >> How to remotely start SQL server on other box.
> >> Thanks for help.
> >>
> >> -Tom
> >
> >
> >.
> >|||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...
>> 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...
>> >> How to remotely start SQL server on other box.
>> >> Thanks for help.
>> >>
>> >> -Tom
>> >
>> >
>> >.
>> >
>
>.
>

How to remotely start SQL server

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
>
>.
>