Auto-Start from Command Prompt

[password99]

Is there a way to set the "Auto-Start service when OS starts" property to True (checked) using the Command prompt?

..similiar to net start mssql$instance_name

 

[BikeBoy20032004]

maybe there's something in SQL Server RK, similar to autostart command in W2K RK.

Why not just set this in Services to start automatically?

 

[password99]

I need to do this for Windows 98 installation using MSDE.

 

[password99]

i found this on one of the websites:

how do i find what this means?

sqlservr -c -s instancename in "binn" folder

 

[mrdenny]

-c tells SQL Server to not run as a service.
-s instancename uses an alternate registry key name (I've got no idea what that actually means).

I believe that to start SQL Server on Windows 98 you need to put sqlservr -c into the startup group since Windows 98 doesn't have services like Windows 2000/XP.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)