Solved

How do i find SQL 2005 product key

Posted on 2009-06-29
7
2,917 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create a linked  server to connect ot an Access Database. 26 46
sql calculate reminders 11 69
Compare data between two databases 16 95
How can I get this column in my query? 2 39
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now