
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-21-2010 03:09 PM
Hi Guys
for licensing purposes I need to know how to differntiate SQL-Servers from MSDEs.
Scanning for Software throws out lots of "Microsoft SQL Server 200x". As far as I can see there are a lot of Desktop Engines among the result.
I do need to identify SQL-Servers only.
Anyhow if I searched for "Microsoft SQL Server Desktop Engine" I get fewer results than expected.
Somehow this result is not reliable.
I have checked the registries of MSDEs as well as of real SQL-Servers. Depending on Version an Patchlevel the keys are all very different and I am unable to recognise a plausible pattern.
Maybe sombody else managed to get correct results on that?
Any clues are welcome!
Lars
for licensing purposes I need to know how to differntiate SQL-Servers from MSDEs.
Scanning for Software throws out lots of "Microsoft SQL Server 200x". As far as I can see there are a lot of Desktop Engines among the result.
I do need to identify SQL-Servers only.
Anyhow if I searched for "Microsoft SQL Server Desktop Engine" I get fewer results than expected.
Somehow this result is not reliable.
I have checked the registries of MSDEs as well as of real SQL-Servers. Depending on Version an Patchlevel the keys are all very different and I am unable to recognise a plausible pattern.
Maybe sombody else managed to get correct results on that?
Any clues are welcome!
Lars
Labels:
- Labels:
-
Report Center
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2010 10:44 PM
If none of the MSDE installs are on actual servers and all of the full SQL installations are, then you could cross-reference by the domainrole value in tblComputersystem table. Anything >= 2 is a server.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-28-2010 04:44 PM
taeratrin wrote:
If none of the MSDE installs are on actual servers and all of the full SQL installations are, then you could cross-reference by the domainrole value in tblComputersystem table. Anything >= 2 is a server.
In my environment that wouldn't always be totally helpful because some people have the server software installed on their workstations for (testing purposes) from MSDN copies. These are the ones I'm trying to track down, as well as validate license count from our servers

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2010 08:26 PM
Maybe this key can be interesting.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
Value "Edition"
Value "Version"
They exist on my sql 2008 machine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
Value "Edition"
Value "Version"
They exist on my sql 2008 machine.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2010 07:53 PM

same here guys, looking for the same answer as lars.vopicka......
id be interested to see if anyone has an answer.
😞

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2010 01:23 AM
I am also looking for something of this nature. Even doing a query for just SQL Server I'm getting a lot of Desktop Engine's showing up. Anyone have any ideas?
