Monday, March 26, 2012

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

No comments:

Post a Comment