Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to tell if instance is MSDN licenced or not Expand / Collapse
Author
Message
Posted Wednesday, September 4, 2013 7:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:29 AM
Points: 45, Visits: 230
Hi,
I've been evaluating SQL Server 2012 for a while now and have started to use it in production. I am concerned that my evaluation install media (MSDN) has escaped into the production environment, but don't know how to check for sure. Is there a property or something to indicate which license key was used to install the instance so I can check where they've all come from?

Thanks
Post #1491295
Posted Wednesday, September 4, 2013 7:50 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 33,088, Visits: 15,197
I'm not sure there's an easy way. I saw someone say if a productID wasn't entered, it's MSDN, but I think that's changed.

Ultimately, I'm not sure it matters. The licensing is decoupled from the installation. If you have enough licenses for what you are running, you should be fine.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1491307
Posted Wednesday, September 4, 2013 7:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:29 AM
Points: 45, Visits: 230
I think you're right. The more I read into this area the more it seems that the actual installation media/licence doesn't matter so long as the safe has enough legit licenses in it.
Post #1491314
Posted Thursday, September 5, 2013 7:19 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
An idea, not verified. Check the SQL Server logs. When an instance is starting it logs a lot of information. If it's a time bombed evaluation version perhaps even that is logged.
Post #1491775
Posted Thursday, September 5, 2013 8:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 33,088, Visits: 15,197
MSDN instances aren't time limited. Eval is, and that is reported with logs, @@versions, etc.

I'm not sure MSDN is anything other than linked to a specific product id.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1491808
Posted Thursday, September 5, 2013 8:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:29 AM
Points: 45, Visits: 230
I've been looking at this for a few days now and I can't find anything to indicate that the MSDN media is in anyway identifiable post install. I believe that the earlier suggestion that "you can't tell" and "so long as you have the licenses it doesn't matter" is probably the correct answer.
Post #1491815
Posted Friday, September 6, 2013 9:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 206, Visits: 819
mike.dinnis (9/4/2013)
I think you're right. The more I read into this area the more it seems that the actual installation media/licence doesn't matter so long as the safe has enough legit licenses in it.


The install media won't matter except for Full/OEM differences. The versions on MSDN are full copies exactly the same as you buy in a shop - the licence key will determine whether you can use it for production.
You should be able to check the key applied to the installation against your (and probably your colleagues) keys on your MSDN subscription.
Post #1492313
Posted Sunday, September 8, 2013 8:28 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, June 1, 2014 8:05 PM
Points: 535, Visits: 430
The way to think of licensing, especially if you've been through a few audits, is that licensing is paper based. Licensing is not handled by the SQL Dev team, it's a separate department in Microsoft. The upshot being, there is no reliable way of telling what type of licence covers an install, it comes down to reconciling what licences you have with your install base. Microsoft or your licence reseller can help you by providing a list of what licences you have (assuming you are covered by an EA), you can match that up with what you have installed.
Post #1492645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse