Steps for Updating SCVMM 2012 R2 to Update Rollup 1

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.

    1. Download the Hotfixes HERE
    2. Extract the MSP files from the CAB files by double clicking on the download CAB then right-clicking the MSP file and choosing extract.

image[13]

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]
(
@ID uniqueidentifier,
@ObjectID uniqueidentifier,
@ObjectType int,
@RoleID uniqueidentifier,
@UserOrGroup varbinary (85),
@ForeignAccount nvarchar (256),
@IsADGroup bit,
@ExistingID uniqueidentifier = NULL OUTPUT
)
AS
SET NOCOUNT ON
SELECT @ExistingID = [ID] FROM [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
WHERE [ObjectID] = @ObjectID AND [RoleID] = @RoleID
AND
— 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)
BEGIN
INSERT [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
([ID]
,[ObjectID]
,[ObjectType]
,[RoleID]
,[UserOrGroup]
,[ForeignAccount]
,[IsADGroup]
,[IsOwner]
)
VALUES
(
@ID,
@ObjectID,
@ObjectType,
@RoleID,
@UserOrGroup,
@ForeignAccount,
@IsADGroup,
0
)
END
SET NOCOUNT OFF
RETURN @@ERROR
/* script ends here */

5. Execute msiexec /update kb2919248_AdminConsole_amd64.msp

 

Version Before: 3.2.7510.0 Version After: 3.2.7620.0
image image

***You can also check out the Video put out by the SCVMM Support Team on the deployment process HERE.

Advertisements
This entry was posted in Hyper-V, SCVMM, Virtual Server Technology and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s