Updating from sp2 to sp3

31-Jul-2019 14:37 by 9 Comments

Updating from sp2 to sp3

I then re-applied SP2 to only Client tools, and everything ran successfully (again, first time did too) but still, no version update for management studio.

I didn’t expect to come across so many issues that people had experienced but I was thankful for information as it kept me ahead of the game in knowing what to watch out for.The reply details both how to uninstall a specific version of SSMS and then how to subsequently troubleshoot issues with installing SP3.I got the Error in sql server sp3 installation log which caused this: Error Number : 29538 Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1Below are the steps that I followed for MY upgrade.The updates executed as expected following these steps so hopefully they will save others some headaches and/or time scouring online for a resolution to a task gone sideways.Client Access servers are the first server role to update, and you should begin with the internet-facing site if you have multiple sites in your organization.

For Client Access servers that are in a CAS Array you should remove some of the servers (eg half of them) from the load balancer configuration, upgrade them, re-add them to the load balancer, then repeat the process with the remaining Client Access servers in that load balanced array.At the time of this writing there are some points in the various release notes that aren't correct or fully updated yet that Microsoft are still working on or that are worth some clarification: You should also plan to update any management tools installations you have on admin workstations or servers, and also check your third party applications that integrate with Exchange in case they also need updated management tools.I'm going to walk through the upgrade process in some more detail next, and also provide some general guidance afterwards about the Service Pack 3 installation steps as well as what to expect in terms of timing and service interruptions.Updating is completely automatic via Windows Update.You can read more about the individual fixes and improvements on Microsoft's Windows 10 Update History: Version 1703 page.If you have an AD forest topology with multiple domains, or process restrictions that require schema updates to be managed a certain way, you can apply the Exchange 2010 SP3 schema update on a 64-bit domain controller that is in the same AD site as the Schema Master, using an account with Schema Admins and Enterprise Admins rights.