I'm trying to automate opening the firewall for an instance of SQL.

For a given instance of SQL how do I find the path to the executable ?

I like to use Process Explorer from sysinternals (now acquired by MS). Just
mouse over the process name, and it'll show you the image path.

Now, if the instance is not running, this won't tell. But you can always
look into the registry under
HKLM\SYSTEM\CurrentControlSet\Services\MSSQLServer \ImagePath for teh default
instance and HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$<inst ance
name>\ImagePath for a named instance.

Linchi

"Michael Tissington" wrote: