Solved

How do i find SQL 2005 product key

Posted on 2009-06-29
7
2,950 Views
Last Modified: 2012-05-07
I have a new client who has MS SBS2003 server and SQL 2005 .
The previous IT suppliers installed it.
We want to migrate to a new server but cannot find the SQL2005 software or disks.
It may have been bought as an open licence but Microsoft have no records of there company.
How do we find the product key on the old server
0
Comment
Question by:tcn_ltd
7 Comments
 
LVL 15

Expert Comment

by:mohan_sekar
ID: 24737093
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24737138
Hello tcn_ltd,

try some third party tools

http://www.nirsoft.net/utils/product_cd_key_viewer.html

Regards,

Aneesh
0
 
LVL 4

Expert Comment

by:vbgb
ID: 24737325
Hi

Produkey v1.35 works with SQL Server 2005 - it lists the Product ID and the Setup Key

http://www.nirsoft.net/utils/product_cd_key_viewer.htm
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:tcn_ltd
ID: 24737481
Produkey from nirsoft only finds the product key for sql 2000 which shipped with the sbs server.
The sql 2005 which was added later it does not recognise unless it is useing the same key?
0
 
LVL 4

Accepted Solution

by:
vbgb earned 500 total points
ID: 24738131
That's odd - it works for us:

SQL Server 2003 R2 (not SBS though, which must be causing your problem)
SQL Server 2005 Workgroup edition
0
 

Author Comment

by:tcn_ltd
ID: 24745248
I think now that SQL2005 was put on as a trial and taken off but left some directories.
They are in fact useing sql200
Thanks for all your help
0
 
LVL 1

Expert Comment

by:SaulRight
ID: 33448144
Is Nirsoft's key finder virus free?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

As the Marketing Director for the company I work for, time is a commodity that I have relatively little of.  My time is divided between coaching my team, creating a direction for our company's future AND actually getting stuff done.  As a result, I …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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