Prism Patch Manager 7.0 SP1 Remote SQL Configuration Changes that may affect other applications using the Remote SQL Server

Prism Patch Manager 7.0 and higher Remote SQL Configuration Changes that may affect other applications using the Remote SQL Server

Description:  This article explains Remote SQL Server configuration changes made during Prism Patch Manager 7.0 and higher Installation that may affect other applications.

Information:  Below are the instance-level changes that are performed during the installation of Prism Patch Manager 7.0 and higher when installing to a RemoteSQL server that may affect other applications running on the instance:

1. The 'xp_cmdshell' option is disabled.
2. The 'Agent XPs' option is disabled.
3. The 'clr enabled' option is disabled.
4. The 'remote access' option is disabled.

If other applications running on the instance require any of these options to function, it is recommended to re-enable the option required Prism Patch Manger 7.0 or higher installation is complete.

Other Option:   Create a new instance on your Enterprise SQL server just for the Prism Patch Manger 7.0 or higher install.  These changes then only affect that instance.