SQL 2008 multiple Registry entries in 64 bit server

Question

I have installed SQL Server Express edition 32-bit on my 64 bit Server 2008 system.

I have found that multiple Registry entries are created in both WOW6432Node and 64-bit registries.

Is Microsoft creating both the keys by default or is it an error(from the package)?

If Microsoft creating those registries, please let me know the Reason

Thank You

Answer 1

Do you have another ( a default ) instance installed on the machine?

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

This is a fresh installation with no previous instances installed.

Answer 3

Hello,

Have you consider that the SQL Server Native Client ODBC driver comes with Windows and is named SQLNCLI? Maybe you are seeing registry entries belonging to that driver.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

I am sure that it is not from SQL server Native Client, because I haven't found them before installation.

But, Could you plz help me how to identify the SQL server is 32 bit or 64 bit from registry (independent of SQL server versions 2005/2008/2012)?

I need this to be identified from installshield script.

Answer 5

Would you please check-out

http://stackoverflow.com/questions/141154/how-can-i-determine-installed-sql-server-instances-and-their-versions

FOr 32 bit instances you may trying

HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\Microsoft\Microsoft SQL Server\Instance Names

instead of

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

http://msdn.microsoft.com/en-us/library/ms210334.aspx

---

FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.