Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL Server 2008 R2 installed on my computer. I want to install Service Pack 1 for SQL Server 2008 R2. Do I need to select upgrade option or new installation during installation of service pack or remove current installation and install SQL Server again.

I am trying to select "new installation or add new features" on first page of installation and then selecting current instance on next page but It is giving some error like registry value invalid.

share|improve this question

migrated from Feb 20 '12 at 6:10

This question came from our site for professional and enthusiast programmers.

Server Fault - or super user or put some more info in please.... – Preet Sangha Feb 20 '12 at 4:57
What edition of SQL Server is it, Express or other? Where did you get the download file? – Aaron Bertrand Feb 20 '12 at 17:33

It sounds like you're running the wrong file.

Download one of the files from and then run that. It shouldn't prompt you for "new installation or add new features", it should prompt you for which instance you want to apply the service pack to.

share|improve this answer

You are running the SQL server setup wizard which is not what you need. To patch your instance after you have installed SQL server, get the respective patch from Microsoft, which is a single file, and then run this file on your server.

I believe @Rob has provided a link from where you can get your respective patch. Download this file, and run it (run as administrator if required), and follow the installation instructions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.