Tuesday, April 7, 2009

Creating a Service on Windows XP or Windows Server 2003

To create a custom service on Windows:
  1. Start>Run>CMD (get to a command prompt or CLI for short)
  2. sc is the command to create the service
example service creation format

sc \\server create "MSSQL$ACT7" binPath= "C:\Program Files\Microsoft SQL Server\MSSQL$ACT7\Binn\sqlservr.exe -sACT7" DisplayName= "MSSQL$ACT7" depend= "SQLAgent$ACT7"

This will create a custom SQL Server example for an ACT database.

No comments:

Post a Comment