Control Service Issue

hess_joel · Post by **hess_joel** » Fri Dec 16, 2005 11:33 am

I'm using the Install MSI plugin to install the MSDE after the Apply Install Action, then trying to use the Control Service Action to start the SQL instance that was just installed, but it doesn't seem to be working. I am specifying "MSSQLSERVER" for the service name and Start the service on install option.
I can start the service via a batch file, but it looks kind of sloppy.

Ideas?

BTW, as a recent Installshield convert, I've been very impressed with the quick response to questions posted here.

Thanks,

Joel Hess

Gizm0 · Post by **Gizm0** » Fri Dec 16, 2005 1:46 pm

The default name of MSDE is trully MSSQLSERVER or MSSQL$INSTANCENAME.So if you are specifying an INSTANCENAME parameter at your install, you should use that as the Service Name.

~InstallAware Clipboard Data~
~Control Service~
~{4CEE83AC-E2A5-49BE-BCB8-BCF1086E7261}~
~MSSQLSERVER~
~~
~0~
~2~
~TRUE~

This is the a sample code to control a service on Installation.
Note that you have to check "Wait for service state change completion".