Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Differentiate between MSDE and full blown SQL Server
Options
Previous Topic Next Topic
Lars.Vopicka
#1 Posted : Thursday, January 21, 2010 2:09:36 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 29
Location: Kassel, Germany
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
Back to top
KHabershon
#2 Posted : Monday, April 05, 2010 11:23:01 PM

Rank: Premium user

Groups: Premium Users
Posts: 48
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?
Back to top
LithiumKid1976
#3 Posted : Wednesday, May 05, 2010 5:53:47 PM

Rank: Premium user

Groups: Premium Users
Posts: 70
Location: ireland
Brick wall

same here guys, looking for the same answer as lars.vopicka......

id be interested to see if anyone has an answer.

:(
Back to top
Lansweeper
#4 Posted : Wednesday, May 05, 2010 6:26:43 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
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.
Back to top
taeratrin
#5 Posted : Wednesday, May 05, 2010 8:44:19 PM

Rank: Premium user

Groups: Premium Users
Posts: 214
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.
Back to top
derek.rose
#6 Posted : Friday, May 28, 2010 2:44:52 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 63
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
Back to top
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba