Thursday 10 January 2019

Setup is missing an installation prerequisite: Microsoft System CLR Types for SQL Server 2012

Or, The Microsoft Report Viewer 2012 Redistributable is required for this feature. Please close the console before installing this package
Or, WSUS Server report viewer prerequisites on Windows Server 2016
Or, Download Report Viewer for WSUS Server 2016
Or, Download Microsoft System CLR Types for SQL Server 2012

Descriptions: This is a very common problem you may face after installing a fresh WSUS server when you try to view any detailed report of reported patches or detected client machines. As the error message you have been encountered with is self-explanatory, you have to download and install two major prerequisites in order to be able to view the desired reports.

You can download these prerequisites from the Microsoft’s site given for reference below:

Downloaded setup files (this is how it should look like):











Error Message Reference-1: When you try to view any report, it would ask you to install report viewer













Error Message Reference-2: When you try to install report viewer without having ‘Microsoft System CLR Types for SQL Server 2012’ already installed, it would ask you to install this component first














Steps: Install these two prerequisites in the sequence given below
1. Close the WSUS Server console if it’s open
2. Install SQLSysClrTypes.msi that you have downloaded already as explained in the description section
3. Install ReportViewer.msi that you have downloaded already as explained in the description section
4. Re-Open WSUS console

Cheers, please write me back if you have any query or feedback on this.

Wednesday 9 January 2019

How to change VMware vSphere Update Manager’s IP Address?

Or, Re-register update manager server with vCenter Server
Or, Re-register update manager with the vCenter server after changing the IP address of update manager
Or, How to use update manager utility to re-register update manager with the vCenter server?

Descriptions:  You might need to re-register the Update Manager with vCenter Server in certain situations, for example when the IP address of vCenter Server or Update Manager changes. You do not need to worry, because it may not take more than 5 minutes if you do it correctly with the correct approach.

Prerequisites:
1. Stop the Update Manager service
2. vSphere vCenter Server administrator credentials

Error message reference:
The similar error may be reported when Update Manager has not been reconfigured after changing the vCenter Server IP address or Update manager has not been re-registered in the vCenter server after changing the IP address of Update Manager

There was an error connecting to VMware vSphere Update Manager - [x.x.x.x:443]. The request failed because of a connection failure. (Unable to connect to the remote server)

Or,

There was an error connecting to VMware vSphere vCenter Server - [x.x.x.x:443]. The request failed because of a connection failure. (Unable to connect to the remote server)


Steps: Re-register update manager with the vCenter server

1. Login to Update Manager Server
2. Go to the update manager’s installation directory path C:\Program Files(x86)\VMware\Infrastructure\Update Manager
3. Right Click on VMwareUpdateManagerUtility.exe and Choose Run as Administrator
4. Provide all the details as requested e.g. IP Address, User Name, and Password of vCenter Server
5. Click on Login














6. In the Options pane of the Update Manager Utility, click on Re-register to vCenter Server.
7. In the Configurations pane, provide the connection and authentication details as requested e.g. IP Address, User Name, and Password of vCenter Server
8. Click Apply





















9. Finally, the confirmation pop-up will appear, and you would be requested to restart the Update Manager Service
10. Click OK, and Close the Utility Windows




















Restart the Update Manager services, and the Update Manager server would be re-registered now.

Cheers, Please write me back if you have any query or feedback.