This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
google44
Level 4
‎Jun 26, 2008 09:05 AM

How to know if SQL Server is installed on the local machine?

Does someone know a better and foolproof way to know if any version of SQL Server is installed or not on the local machine, besides verifying the registry key ?
Thnaks
Labels (1)
Labels
0 Kudos

(1) Reply
Gvarma
Level 7
‎Jun 26, 2008 04:02 PM

google44 wrote:
Does someone know a better and foolproof way to know if any version of SQL Server is installed or not on the local machine, besides verifying the registry key ?
Thnaks


If you dont trust the registry keys...then you could perhaps use the ServiceStartService() and ServiceStopService() to stop and start the MSSQLServer on the end users machine.

if MSSQLserver stops and starts sucessfully then SQL Server exists, however you will have to use somewhat Registry lookup to also make sure use has the version of SQL Server that your application supports.

HTH
0 Kudos