2

I have SQL Server 2016 RTM installed and would like to update it to SP1. When I run an SP1 cumulative update, it fails because there is nothing to update. Presumably this is because it needs SP1 to be installed first. When I run the SP1 installer, it wants to create a new instance.

How can I update an existing instance from RTM to SP1 without having to uninstall and reinstall the instance?

1 Answer 1

5

It sounds like you've downloaded a copy of the full SQL Server 2016 (with SP1) installer. (Microsoft often distributes the installer with the latest service pack built in.)

Instead, download Service Pack 1 by itself, then apply the latest cumulative update.

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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