Registry key missing to verify installation, SQL Server is installed

Hi All,

I have come across one scenario where i have installed SQL server 2008 , but in the registry i do not see the \\InstaceNames\\SQL key.

I am using the registry check to detect the presence of SQL server 2008 Sp3 or Higher in the way given below. Read the instance names under they key HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL\\ , For the names, check the "data" filed value•
The same data field value will be added as registry key entry down, So check the current Version of HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\\Microsoft SQL Server\\"Same Data FieldValue"\\MSSQLServer\\CurrentVersion) .

The above check has been successfull in all the cases. In one scenario in Win 7 32 bit OS,i do not see the registry entry HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL\\, i,e \\Instance Names\\SQL\\ is not available even though SQL 2008 is installed.

Any help will be greatly appreciated.

more ▼

asked Apr 20, 2012 at 08:04 AM in Default

avatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

"Is installed" does not necessarily mean it is running. The fact that if this key structure is missing SQL Server will not even start. I tested this by renaming the Instance Names key on my SQL Server instances, and it would no longer start after restart.

This key has to exist in order for SQL Server to detect the start up parameters that are stored within the registry hive for the instance.

Can you verify that the instance is running, or runnable?

more ▼

answered Apr 22, 2012 at 02:15 PM

avatar image

6.6k 21 26 34

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 20, 2012 at 08:04 AM

Seen: 2510 times

Last Updated: Apr 22, 2012 at 11:09 PM

Copyright 2018 Redgate Software. Privacy Policy