1

I need to obtain Microsoft SQL Server 2005 Service Pack 2 as part of a rollback plan for an upgrade to SP3. All links on the Microsoft website seem to be broken. This will be installed on a very safety sensitive system and I would prefer to obtain the installer from the official Microsoft website. I am able to obtain a download link on MSDN, but it says "No product key is required" so I'm assuming it wont even give me an option to enter a license key when I install it.

Where is the safest place to obtain a Microsoft SQL Server 2005 SP2 installer (iso or exe)?

2

That message is simply saying you won't need to enter a product key at installation.

The version from the MSDN downloads is the best download to use.

The SQL Server installers downloadable via MSDN subscriptions don't require at license key - the installer asks you what edition you want to install. I'd recommend downloading the full installer for SQL Server 2005 from MSDN, installing it on a virtual machine for test purposes to see how the installer works. The last thing you want to do is try to figure out how to install it as part of your rollback effort.

  • 2005 SP2 is currently installed and we are planning to upgrade to SP3. If things go haywire we want to be able to rollback to SP2 which involves uninstalling SQL and reinstalling. Is there any place I can download a base SQL 2005 so I can patch it back up to SP2? – Brad Sep 22 '16 at 14:47
  • 1
    Thanks. I found the SQL 2005 Enterprise edition installer on MSDN. I'll fire up a Windows 2003 server and give it a shot – Brad Sep 22 '16 at 15:05
  • 2
    The Product Key field in the installer was greyed out and pre-filled with a key (presumably an MSDN licence key). I was able to override this by running the installer via the command line: start /wait setup.exe PIDKEY=XXXXXXXXXXXXXXXXXXXXXXXXX. – Brad Sep 22 '16 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.