Solved

How do i find SQL 2005 product key

Posted on 2009-06-29
7
2,902 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server DeDupe Table 3 29
SQL Date from a string 4 50
What is the best way to calculate hours worked 5 51
Truncate vs Delete 63 87
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

13 Experts available now in Live!

Get 1:1 Help Now