Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is there any easy way to find out what license(s) are associated with a running copy of SQl Server, or Windows Server 2008?

I have technet subscriptions, and an MSDN subscription, but sometimes I also use a trial software if I need to quickly get a test environment up for a short amount of time. I have plenty of legal licenes for all the software (they are all just for test/development), but I don't accidentally want one of my 'trial licenses' to expire unexpectedly....how can I tell if I am running a trial version or not?

share|improve this question
    
Just so everyone who reads this is clear, TechNet and MSDN software does not expire. You can download 60-day trial versions from Microsoft's website that do expire after the timeout period. –  Carl Campos Jul 14 '09 at 16:44
    
Yes, I agree, but sometimes I do use trial software even though I have technet?MSDN licenses, (just so I don't have to bother going to the MSDN site and creating a license key), but your point is valid. –  EJB Jul 15 '09 at 12:50

4 Answers 4

up vote 2 down vote accepted

For Windows 2008, I believe you can identify a trial version through looking at the System option of the Control Panel, then scroll down to Activation. If it is a trial, it should say something like "60 days to activate." Running winver from the command line should also tell you.

For SQL Server, I think if you go into SQL Server Management Studio then choose Help, About, it will display the days remaining on the right hand side.

share|improve this answer

For SQL Server you can run the following query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
share|improve this answer

For SQL server the query is:

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY ('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition; GO

see SERVERPROPERTY (Transact-SQL) For Server 2008 the command is (from a command prompt)

cscript slmgr.vbs -dlv

share|improve this answer
    
You are missing a paren "(". SERVERPROPERTY 'ProductLevel') –  Nathan Hartley Jul 27 '09 at 15:50
    
@nathan I corrected it - thanks! –  Jim B Jul 27 '09 at 16:14

A handy tool I have used frequently is Magical Jellybean. It pulls the license key for most MS software, as well as a slew of other popular programs. You can check it out at http://www.magicaljellybean.com/keyfinder

Since we're a small company we use a lot of retail licenses along with volume licenses. This tool makes it real handy identifying who has what.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.