Home » SQL Server

How to Exactly check the SQL license?

G'day all

How can i check SQL license, if it is a DEMO or full

i used

select serverproperty('LicenseType'),serverproperty('NumLicenses')

But it does not tell exactly which license i have.

Please help


SharePoint 2007 (Administration/Development) Web developer and .NET DTS Programmer .NET Framework 2.0/3.5 SQL Server 2008/2005/2k

1 Answer Found


Answer 1

Hi ,

Sql server will not track licensing information anymore through registry keys . Please check  the following MSDN article for further information .


To check wether u have a orginal copy u can check the following . Please use Installed sql  Server features dicovery report shipped with SQL Server 2008, it will list all SQL Server 2000/2005/2008 features installed on your server.

To open Installed SQL Server features dicovery report: Open Start --> All Programs --> Microsoft SQL Server 2008 --> Configuration Tools --> SQL Server Installation Center, and then click Tools page --> Installed SQL Server features dicovery report in the SQL Server Instalaltion Center.

From the below link you can find werther it is a evalution days of expiration information  ....
http://insanesql.blogspot.com/2009/01/evaluation-editiondays-remaining.html : Evaluation Edition(Days Remaining)

Thanks,Suhas V


Hi all,
I have some more questions regarding SQL licensing that need your advice, can you kindly explain me about Open License(OLP) and Developer Edition of SQL server.
a. If I have a team of around 20 members with 5 database developers, and 3 servers installed with SQL server for developing. The servers are only used for my team to develop software only, not production.

Which license type is suitable for my team(OLP of Standard/Workgroup Edition or licenses of Developer Edition)?

+ Can I buy 3 licenses of  SQL server Developer Edition to install on my 3 servers? If yes, do I need to buy any other licenses
 for the database developers to access the servers?
+ or the SQL server Developer Edition can only be installed on developer computer? Then I must use other kinds of license like OLP of Standard/Workgroup Edition to install on 3 servers and buy CAL for my developers?

b. I see in a price list these records:

1.SQL Svr Standard Edtn 2008 Sngl OLP NL                 992 USD
2.SQL Svr Standard Edtn 2008 Sngl OLP NL 1 Proc       6,339 USD
+ What are the differences between those 2 item? how many processors or servers can 1 license of item.1 can be applied?
+ Item.1 requires CAL for devices, users to access; Item.2 does not, is it correct?
+ Those 2 items should be used for production servers, and development team do not need to use them, am I right?

Thank you


I installed SBS 2008 Server Primiun edition a few month ago, and was unware that I have to enter a product key as the installtion automatically provide a key which is greyed. It seems that a trial version was installed has now expired and the SQL server has stopped working. The question is that there is anyway that I can just enter product key of SQL 2008 for small business without change anything as currently the SQL server is in a production enviroment where two separate ERP programs are running.

I have also encountered a problem to choose Version upgrade, the Setup Support Rules failed to Restart Computer (which I have a started a couple of times). I have read a solution within forum (http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/224ce4b0-9a7a-4fe3-9cf0-0afe60d0e94a) about this and I have not got anchance to try it yet.

Thank you for your help

At initial install of SQL Server 2008 R2 November CTP there was an option to use the Evaluation Version License Key or enter an actual License Key. We installed using the Evaluation Key. Will we be able to update the key to an acutual License once available? If so, what is the process for updateing the License Key from Evaluation to RTM. I ahve had many past experiences where RTM License Keys required new RTM Media.  

We have Installed the SQL 2008 R2 Evaluation version on our server but we purchased the SQL 2008 standard edition how can I migrate the data and install the SQL 2008 edition that we are licensed for.



Hello All

'How to check the reboot history of SQL server services in  SQL server 2008.'

I am trying to find out the reboot history of sql server services. My temp db was full and so I want to check when my SQL server services were reboot last time.

Thank you in advance.


logon to SQL Server management studio and connect to the master database instance

The after that you run this script against the master database instance only...

Highlighted Below:


DECLARE @crdate DATETIME, @hr VARCHAR(50), @min VARCHAR(5)
SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'
SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60
IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0
SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))
SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))-((DATEDIFF( mi, @crdate,GETDATE()))/60)*60
PRINT 'SQL Server "' + CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME'))+'" is Online for the past '+@hr+' hours & '+@min+' minutes'
IF NOT EXISTS (SELECT 1 FROM master.dbo.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher')
PRINT 'SQL Server is running but SQL Server Agent <<NOT>> running'
PRINT 'SQL Server and SQL Server Agent both are running'

Hello gurus!

Firstly I want to apologies if this question is out of place here.. if someone can direct me to the correct forumn great and Thanks!

I have a VB.NET application which uses its own Backend Database (MSSQL Server). I need to distribute this application to sites where there will be an existing SQL Server.

So I will need to Create the Database on this server. The Application includes methods for building the database on startup if not already connected to one.

However the users windows logon may not have the correct permission to connect and create a Database on the Server. I have a DB Setup form in my application which asks for the Servname, Username, Password and Database name. I have catered for Windows Authentication and SQL Server Authentication within the form - the user makes the choice.

Assuming they enter a Username and Password for SQL Server Athentication then I will be trying to connect using this user and create the database on the given server. The following is my outline logic:-

                                                                  Create db Process
                                                               Check Credentials
                                                                   /                 \
                                                 Dont Work /                    \ Work
                                                                /                       \
                                               Ask if Credentials                 \ 
                                              should be created?                 \
                                                        |                                  |
                                             Prompt for sa                     Create DB
                                                        |                                 Using
                                                        |                             Credentials
                                          Create DB Instance
                                                   using sa
                                            Create Credentials
                                         with New DB as default
                                                  using sa
                                          Generate DB Tables
                                           Using Credentials

So all clear on the western front!

I am using :-
Imports System.Data.Sql
Imports System.Data.SqlClient

What I need to know is how do I access Users to check roles on SQL Server? (Code Samples?)
How do I create the New user on the server and assign ownership of the new database to the new user?
Is this in fact the best method for achieving this?

Thanks in advance for any help forthcoming!
Perth in Western Australia!


It is my understanding that MSDN software, for example Windows 7, is only licensed for dev and test uasge. Also, using Windows 7 as the regular OS on my daily (development) box, from which I send\receive email, is also NOT licensed usage. So........what exactly is licensed usage for an MSDN OS? ( A 30-, 60-, 90- trial install then wiping the disk clean?)




The application will be downloaded from the internet.

The user who dowloads the application must be provided with an Activationkey for the trial license. After that he/she must be able to activate the commercial license via an activation key.

However the activationkeys must be generated by a automatic process to make this work smoothly.

Is there some sample code for this? So each user must be presented with an activationkey to activate the application he/she requested.


We have SQL Server 2008 R2 installed in a lab environment and it has worked well with the business database program we were considering.  We used our technet version of SQL Server 2008 R2 downloaded from the server. 

It is working so well, we are going to purchase SQL Server 2008 R2 and the business database program we were evaluating.  We can convert the evaluation of the business database program to a production version.

Once we purchase the Open License for SQL Server 2008 R2 (~$6,500), can we convert the SQL Software already installed and configured in the test environment to our fully purchased version -- so we can put the server into production.  I believe the product keys are embedded into the download so I wasn't sure if this was possible to convert the technet 'lab' license to a purchased production license without having to uninstall and reinstall.




I have been given the task of auditing our network - I have just gone onto the Eopen License server, checked our licenses through the License Relationship section and noticed a large quantity has License Status = Expired, what does this mean? is the license now invalid or does this mean something else?

Any handy tips for doing an audit would also be great!!! Big job - not much fun!!



I am trying to find an offical statement from Microsoft as to whether a SQL Server license is required when using the SharePoint add-in to show Local Mode reports ONLY (i.e. only using SharePoint lists etc).

My understanding is that no SQL Server license is requred if SharePoint is not actually configure to be Integrated with a Report Server.

If anyone can provide a link or otherwise I would greatly appreciate it.


Dave Hughes



SI can be installed on a machine other than SQL Server.  This raises a question about licensing - should each machine have a SQL Server 2008 R2 license?

So for the following scenario, how many SQL Server 2008 R2 licenses are required?

Server 1 = Database Server (StreamInsight not installed here)
Server 2 = StreamInsight Server (SQL Server DB not installed here)

Let's use Standard edition processor licensing for this example. Would the customer require one processor license or two?

Best regards,





we are going to use SQL Server 2005 Reporting service with our asp.net 2.0 application.

We need various kind of reports as well as some charts.

is it free with SQL Server 2005 ? we will have SQL Server 2005 as database for our web application.

Do we need to pay anything extra to use SQL Server 2005 reporting service?


If you buy a SQL USER Client Access License (CAL) and at some point there after you no require a DEVICE CAL are you able to configure as a once off to change that USER CAL to a DEVICE CAL or do you need to buy a NEW DEVICE  CAL?


Thank you


I thought I had 60 more days left on my trial license.  We lost power and the system rebooted and now says my trial license has expired.  Is there any way to extend the trial license?

So we plan on installing SQL 2008 R2 Standard, but where do you set the licensing up? We have a per processor license, but not sure how to apply it to the install? Thx.
Seems like licensing for SQL Server 2008 R2 is not totally clear and I've called and gotten several answers.  Trying to see if any of the SQL experts/MVPs here may be able to shed some light.

Here is the setup:

16 blade servers - 2 processors per blade.

We are going to have 4 SQL Servers (all virtual).  Each server will have two virtual processors assigned.

The confusing part about SQL Server 2008 R2 Licensing is if we want to be able to run these 4 SQL servers on any of these blade servers would we need to buy a licenses for every processor (32).  By the way that is one of the answers I received during the calls which doesn't seem right.

From the Licensing Quick Reference Guide


For 2008 R2 Enterprise it says:

SQL Server 2008 R2 Enterprise: You may run unlimited instances of the software in up to four (4) OSEs per license within the server farm, and move those instances freely, as long as the number of physical processors supporting or used by the OSEs in which the software is running at any one time does not exceed the number of licenses assigned to the server farm.

So with four Virtual SQL servers if we have them possibly spread across 4 blades that could mean a total of 8 virtual processors which would mean 8 per processor licenses.

Does that sound right?   Seemed easier to track on physical boxes.




Hey folks,

First off, I honestly don't know anything about SQL.  However, our company is currently using 2005 Express, which does not give access to Report Builder.  We figure since we're going to need to upgrade to a different version, we may as well get SQL 2008.  I understand that you have to go 2005 Express -> 2008 Express -> Standard.  My issue is licensing.  There are one or two people here that access the data at any given time, and I'm not sure what each license scheme is, or what we'd need.  Any input in that regard would be extremely helpful. 


Erik J.

We are planning to migrate our all our applications to Microsoft suite of products. We would be using Microsoft Dynamics, Biztalk, Sharepoint portal and SQL Server. The DWH will be built using SQL Server, SSIS, SSAS and SSRS. Do we need to pay additional licensing fees for the DWH bit (i.e SQL Server, SSIS, SSRS, SSAS ) even if we pay licensing cost for MS Dynamics & Sharepoint. If we need to pay additional licensing cost for the DWH bit, could you please give an approximate idea on the costs.

<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure