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.