x

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

Bhavani gravatar image

Bhavani
0 1 1 1

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

1 answer: sort oldest

"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

Shawn_Melton gravatar image

Shawn_Melton
5.3k 19 21 29

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1834
x3

asked: Apr 20, 2012 at 08:04 AM

Seen: 1435 times

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