The update of SCVMM 2012 R2 with Update Rollup one is fairly straight forward with the exception of the need to execute a SQL script after the server component update, but if you have used VMM for any length of time you know that an occasional modification to the database itself is necessary to correct issues. Even with that, the process, should take no more than five minutes to complete. Here are the steps below. Make sure you either perform this in your test environment first or wait a few weeks until others have tested the update just to be sure any unexpected issues have been vetted. There are not a lot of changes in the rollup, I can think of many more that need to be corrected, but having an outage of your main virtual machine management tool is never a good thing.
- Download the Hotfixes HERE
- Extract the MSP files from the CAB files by double clicking on the download CAB then right-clicking the MSP file and choosing extract.
3. Execute msiexec.exe /update kb2904712_vmmserver_amd64.msp
4. Execute the following SQL script: (It is stressed to do this immediately after the server side update)
/* script starts here */
ALTER Procedure [dbo].[prc_RBS_UserRoleSharedObjectRelation_Insert]
@UserOrGroup varbinary (85),
@ForeignAccount nvarchar (256),
@ExistingID uniqueidentifier = NULL OUTPUT
SET NOCOUNT ON
SELECT @ExistingID = [ID] FROM [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
WHERE [ObjectID] = @ObjectID AND [RoleID] = @RoleID
— Select owner OR Select all which matches ForeignAccount or UserOrGroup OR
— both ForeignAccount and UserOrGroup is NULL
(([UserOrGroup] = @UserOrGroup OR [ForeignAccount] = @ForeignAccount) OR
([UserOrGroup] IS NULL AND @UserOrGroup IS NULL AND [ForeignAccount] IS NULL AND @ForeignAccount IS NULL))
/* Ignore duplicate entries */
IF (@ExistingID IS NULL)
SET NOCOUNT OFF
/* script ends here */
5. Execute msiexec /update kb2919248_AdminConsole_amd64.msp
|Version Before: 3.2.7510.0||Version After: 3.2.7620.0|
***You can also check out the Video put out by the SCVMM Support Team on the deployment process HERE.