thomasm1948
asked on
How to Install SSIS without the SQL Server CD
Hi All,
I have an issue where the company that I work for has misplaced their SQL Server CD and I need to configure SSIS on the server. is it possible to install it from the SQL 2008 R2 ENT EVAL ISO without it converting my current installation to the evaluation version?
If so, is there a way for me to retrieve my cd key and re-enter it
Thank you for all of your help in advance
I have an issue where the company that I work for has misplaced their SQL Server CD and I need to configure SSIS on the server. is it possible to install it from the SQL 2008 R2 ENT EVAL ISO without it converting my current installation to the evaluation version?
If so, is there a way for me to retrieve my cd key and re-enter it
Thank you for all of your help in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for all of your help
1..
Use registry to get the key.... <<SOFTWARE\Microsoft\Microso
Open in new window
http://www.sqlservergeeks.com/t-sql-script-to-find-the-cd-key-from-registry/
2..
or you can also use below Microsoft url- <<Here they have provided a generic powershell script to the product key>>
https://gallery.technet.microsoft.com/scriptcenter/Get-SQL-Server-Product-4b5bf4f8
Hope it helps!!