Solved

SQL Server 2005 License Question

Posted on 2011-02-17
3
300 Views
Last Modified: 2012-05-11
I need to move SQL Server 2005 off a dieing server to a new server. My client cannot find any paperwork as to how many licenses(CPU or CALs) they have purchased. I cannot find anything in their current SQL instance that gives me any of that information. From what I have read this appears to be completely on the honor system. I have them going through all of their old invoices but the reseller has been very vague,the invoice just says SQL Server 2005, it does not specify CPU's or CALs. Is there anything in SQL I can check or is there someone I can call at Microsoft who may know this information? I simply want to keep them legal with the new server. They are a small business so it would be an open license.
0
Comment
Question by:rwheeler23
3 Comments
 
LVL 4

Accepted Solution

by:
evgeny_f31 earned 500 total points
ID: 34916739
you can get the sql2005 serial key with this tool
http://www.nirsoft.net/utils/product_cd_key_viewer.html
then ask microsoft
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 34916850
Take a look at NumLicenses and LicenseType return from SERVERPROPERTY:
http://msdn.microsoft.com/en-us/library/ms174396(SQL.90).aspx

SELECT CONVERT(char(20), SERVERPROPERTY('licensetype'));
SELECT CONVERT(char(20), SERVERPROPERTY('numlicenses'));


Unfortunately, you will see that LicenseType is always returned as DISABLED in v2005.  They say this is by design, because SQL doesn't write license detail to the registry during install, like v2000 did.
See here:

http://blogs.msdn.com/b/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx


I would call their License support at (800) 426-9400:
http://www.microsoft.com/licensing/contact-us.aspx
0
 
LVL 12

Expert Comment

by:Máté Farkas
ID: 34916885
CAL Licensing
If the datas provided by the SQL Server are used only in a separated, local network or VPN via Inranet or any Web application then you can count the possible number of users in this network. If this is under 100 or 200 user you should use CAL license.

CPU Licensing
If the data can be accessed by users on the whole internet via any web application, any web servers or connections then you have to use only the CPU license.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question