Detecting SQL Express by Instrance Name

[hsmith]

When I am using the SQL Express pre requisite it checks for the presence of SQL express. However it just generically checks for SQL Express and doesnt check by Instance name.

So if for example another app installs SQL under an instance name of Fred, and my app uses an instance name of Flintstone, then the prerequisite checker thinks SQL is installed (which it is of course) and my app will fail.

How can you circumvent this weakness?

TIA

Howard Smith

[MichaelNesmith]

In the Application Runtimes view, if you highlight SQL Server, and choose Options, you get to configure exactly which instance you want to check for. So you can check for your custom instance as a pre-requisite.

Please note however that you perform the check by the service name, which will be slightly different from your exact instance name. So don't let that throw you off guard.

[hsmith]

Michael

Thanks for quick answer - that solves that one


Cheers

Howard Smith