Finding the path to the sqlserver.exe

Got a problem you cannot solve? Try here.
Post Reply
smeyn
Posts: 12
Joined: Wed Jun 15, 2011 3:41 pm

Finding the path to the sqlserver.exe

Post by smeyn »

After installing a new instance of SQLServer 2008 I need to find the physical path to the specific SQLServer.exe so I can set up a rule in the firewall. Any way to determine the path?
thanks
stephan
giaviv
Posts: 2039
Joined: Fri Dec 17, 2010 1:39 pm

Re: Finding the path to the sqlserver.exe

Post by giaviv »

Hi smyen,

Perhaps it is stored in the registry? You can consult Microsoft and ask them how this location is determined.
Aviv Giladi
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Product Guides - http://www.installaware.com/publication ... guides.htm
InstallAware Help -F1 anywhere in the InstallAware IDE
smeyn
Posts: 12
Joined: Wed Jun 15, 2011 3:41 pm

Re: Finding the path to the sqlserver.exe

Post by smeyn »

Thanks - I found it in the registry.

A comment on ReadRegistry and CheckRegistry: I have an X64 installer and the X64 flag is set right at the beginning. However it appears to become unset during the script, as I got always NO$KEY during the CheckRegistry call. Setting the X64 flag again just before the call did the trick.
Post Reply