sql liscence keys

If you have numerous installations of SQL Server in your infrastructure (with various different versions and licensing models in operation) – when you purchase a new copy of SQL Server – do MS give you a licence key that needs entering before the software is fully functional?
Likewise – when you purchase SQL CAL’s – is there a licence key to enter on the end users’ desktop before the CAL works?
If you have a central log of all software licences, it appears hard to determine were that software has been deployed (i.e. which server it’s been installed on), so if you could tie up licence keys it would be a lot easier.
Second part of the question will be to see if there’s a query to extract the keys to compare to the key entered to activate the software with the inventory of purchases licences.
LVL 3
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Cris HannaCommented:
Typically this would fall in the category of Volume Licensing and what's called a MAK (Multiple Activation Key)
You can learn more about it here http://www.microsoft.com/licensing/activation/existing-customers/product-activation.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kevinhsiehCommented:
When I buy Microsoft SQL through a volume licensing program there are no keys that need to be entered into any system. This is true for SQL Server and SQL CALs. I don't go through any sort of activation process with SQL.
0
pma111Author Commented:
in that case do you have procedures to document what was installed where? to keep track on things?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

kevinhsiehCommented:
I use a spreadsheet to keep track of where I have SQL Server installed.
0
pma111Author Commented:
For volume liscensing and mak keys is it normally per version ie one volume and mak kry for sql 2008 another for sql 2005 etc or can they cover both?
0
kevinhsiehCommented:
There are no MAK or KMS keys for SQL, so there is nothing like that to keep track of.
0
Eugene ZCommented:
try to use Microsoft Assessment and Planning Toolkit (MAP) tool that will give you details about what sql servers and kind licenses you have

http://msdn.microsoft.com/en-us/library/bb977556.aspx

=---

about keys
if you have installation DVD you will see the # during installation
BTW: what is your sql server version\edition?
e.g. sql express is for free...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.