Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Missing SQL Servers from Computer Group
0 views
Skip to first unread message
JerryW
Apr 10, 2006, 4:26:02 PM4/10/06
to
I noticed that many of our SQL 2000 servers are not being discovered as such.
It looks as though the group is based on the existence of the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo
It looks as though the group is based on the existence of the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo
Sure enough, some of my server have this, others don't (all SQL2000). Any
idea why this is occurring? Can I just do a reg import to fix the problem or
is there a better way?
Thanks!
-J
Pete Zerger
Apr 11, 2006, 1:03:10 AM4/11/06
to
Hello JerryW,
Do the servers without the appropriate key have anything in common (MSDN
media, etc)?
Kind Regards,
Pete Zerger MCSE(Messaging)
mail:pete....@nospam.gmail.com
BLOG:http://www.it-jedi.net/
JerryW
Apr 11, 2006, 10:11:02 AM4/11/06
to
They are all developement servers installed from MSDN media. I noticed that
the servers that were being recognized as SQL2000 servers had an additional
component installed such as Reporting Services which must have created the
key.
the servers that were being recognized as SQL2000 servers had an additional
component installed such as Reporting Services which must have created the
key.
Pete Zerger
Apr 12, 2006, 1:37:43 PM4/12/06
to
this is the registry key that indicates a SQL 2005 installation
SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
Is it present on any of the servers in question?
JerryW
Apr 12, 2006, 1:38:02 PM4/12/06
to
In case anyone else is interested...
The root cause of the problem is that SQL Server was installed from the MSDN
media - the installation does not create the appropriate key unless you
install something like Reporting Services or setup DTS. I've imported the
key from a working non-MSDN server and that seems to be working for the last
several days.
The root cause of the problem is that SQL Server was installed from the MSDN
media - the installation does not create the appropriate key unless you
install something like Reporting Services or setup DTS. I've imported the
key from a working non-MSDN server and that seems to be working for the last
several days.
I've also been told from an MS employee that the SQL MP was not design to
support MSDN media-based server installations, but it *should* still work.
0 new messages