Documentation forPatch Manager

Configure the Patch Manager Web Console

Beginning in Patch Manager 2022.2, when you install the Orion Platform on the Orion server, the installation procedure automatically installs the Patch Manager Web Console (or Integration Module) on the Orion server. When the installation is completed, configure the Patch Manager Web Console using the procedures in this section.

When you are finished, the Orion Services connect to the Patch Manager database through the Patch Manager Service running on the Primary Application Server (PAS). If you purchased a Patch Manager license, you can also check your product license.

The PAS is a dedicated server that hosts the PAS role. This server provides the default management group, certificate configuration authority, and communications hub for your Patch Manager deployment.

After the Orion Services retrieves and caches the data to the Orion database, it displays in the Patch Manager Summary view in the Orion Web Console.

See the Orion Platform Administrator Guide for details about customizing the look, views, settings, charts, and maps for your Orion products.

Make sure that your user account includes login credentials to the SQL database server hosting the Patch Manager (EminentWare) database. You can use Microsoft SQL Server Management Studio to add your login credentials to the database.

To configure the Patch Manager Web Console, perform the following procedures:

  1. Verify that the Orion server is running SolarWinds platform 2022.2.

    See the Orion Platform Installation and Upgrade Guide for installation instructions.

  2. Locate the server name or IP address and port of your Primary Application Server.

  3. Create or select a dedicated local administrator account in the Patch Manager Administrator Console.

  4. Configure the SQL Server settings for Web Reports, and then restart the EminentWare Service.

  5. Log in to the Orion Web Console and access the Patch Manager settings.

  6. Set up the Web API settings so the Patch Manager Web Console can communicate with the Patch Manager Primary Application Server.

  7. Verify that you can access the Patch Manager Web Console.

  8. Configure the database settings for the Patch Manager reports. When you are finished, you can access the Patch Manager reports in the Orion Web Console. These reports provide details about your managed computers.

Create a dedicated local administrator account

This account will only be used to create a communications link between the Patch Manager application and the Patch Manager Web Console on the Orion server using the Web API.

  1. Create a local administrator user account with Windows credentials and a unique name.

    For example: 

    SPMWebAPIUser

    You can also select an unused local administrator account.
  2. Record the user name and password for a future procedure.

  3. Log in to the Patch Manager Console as an administrator.

  4. Add the user account to the EminentWare Users security role.

  5. In the navigation pane, expand Patch Manager System Configuration and select Security and User Management.

  6. Select the Security Roles tab.

  7. Select EminentWare Users.

  8. Verify that the dedicated local administrator account displays in the bottom center window pane.

Configure the SQL Server settings for Web Reports

Ensure that all Named Pipes and TCP/IP protocols are enabled in the Patch Manager SQL server configuration. Web Reports require these protocols enabled on the SQL Server instance where the EminentWare database is located.

See the SQL Server Configuration Manager documentation on the Microsoft technical documentation website for instructions on how to use the Configuration Manager.
  1. Open the SQL Server Configuration Manager.

  2. In the navigation menu, maximize SQL Server Network Configuration and select Protocols for SolarWinds Orion.

  3. Enable the following protocols:

    • Named Pipes - Allows multiple connections to the SQL database from different machines

    • TCP/IP - Allows a remote connection to the SQL database from a different machine

  4. Double-click TCP/IP.

  5. Click the IP Addresses tab.

  6. Under IPAII, verity that the TCP Port is set to 1433, and then click OK.

  7. In the navigation menu, select SQL Server Service.

  8. In the window pane, right-click SQL Server and select Restart.

Restart the EminentWare Service

  1. Log in to the Patch Manager server as an administrator.

  2. Open the Services application.

  3. Right-click EminentWare Data Grid Server and select Restart.

Access the Patch Manager settings in the Orion Web Console

  1. Log in to the Orion Web Console as an administrator.

  2. Click Settings > All Settings.

  3. Locate Product Specific Settings and click Patch Manager Settings.

Set up the Web API

Link the Patch Manager Web Console to the Patch Manager Primary Application Server Web API. This process establishes a communications link between the Patch Manager Web Console installed on the Orion server and the Patch Manager Primary Application Server.

  1. In the Patch Manager Settings window, click Web API Setup.

  2. Enter the server name or IP address of the Patch Manager Primary Application Server.

  3. Verify that the selected Primary Application Server port is open, configured, and listening.

    Open a command prompt and execute:

    netstat -aon | find "54092"

    where 54092 is the port for an unsecure HTTP connection to the Primary Application Server. If you plan to use a secure HTTPS port, enter 54093 for the port number.

  4. Create a connection from the Orion Platform Web Module to the Patch Manager Service.

    Enter 54092 to create an unencrypted HTTP connection.

    To create an encrypted connection using port 54093, select the Use HTTPS checkbox.

  5. Set up the Windows credentials for the Patch Manager server. This account will link the Patch Manager Web Console to the Patch Manager application on the Primary Application Server.

    1. Enter the name of the dedicated local administrator account you created in a previous section.

    2. Enter the account password.

    3. Click Test to verify the credentials.

      If the credentials are correct, Test succeeded displays.

  6. Click Submit.

Access the Patch Manager Web Console

After you set up the Web API, you can access the Patch Manager Web Console in the Orion Web Console at My Dashboards > Patches > Patch Summary.

This view may vary depending on your configuration.

Configure the database settings for the Patch Manager Web Reports

After you configure the database settings, you can generate reports in the Orion Web Console. These reports provide details about your managed computers.

  1. Click Settings > All Settings.

  2. Locate Product Specific Settings and click Patch Manager Settings.

  3. Click Web Console Database Setup.

  4. Enter the IP address of your Patch Manager SQL Server database.

  5. Enter the Windows or SQL server login credentials of a user in your organization with administrator access to the Patch Manager database. These credentials will be used to create a read-only user account to query the Patch Manager database and populate the reports.

    For example:

    SPMWebReportsDBUser

    To prevent unauthorized access to your Patch Manager database, avoid using sa or .\Administrator for your login credentials.
  6. (Optional) Select the Encrypt connections with SSL checkbox to encrypt the network traffic between the Orion server and the Patch Manager SQL database server using the SSL certificate on the SQL server.

    This option requires a provisioned SSL certificate on the SQL server. Forcing the SQL server to require encryption is not required.
  7. Click Connect to test the connection.

    If the credentials are valid, Connection succeeded displays in the window.

  8. Select the SQL Server account used by the Patch Manager database.

  9. Select or create a user account to access the Patch Manager database and populate the reports. This account will be read-access only.

    To use an existing Windows or Active Directory account, select Use an existing account and enter the account name and password. Record and save your account credentials in a safe place.

    To create a new SQL Server account, select Create a new account and enter a new account name and password. Record and save your account credentials in a safe place.

    To use the existing SQL Server account you entered in step 5, leave the current option selected.

  10. Click Submit.

Access the Patch Manager reports

After you configure the database settings, you can access the Patch Manager reports in the Orion Web Console.

  1. In the Orion Web Console toolbar, click Reports > All Reports.

  2. Click the Group By drop-down menu and select Product.

  3. Under Group By, select SPM Reports.

  4. Click a report in the window.

Check your SolarWinds product licenses

Each SolarWinds product includes a license key that enables product use for a specific time period. For example, if you are evaluating Patch Manager, the evaluation license is valid for 30 days.

You can view the license status of each SolarWinds license using the License Details view in the console. The view lists the module name, version, service pack, and the number of days remaining for your product license.

For SolarWinds product license details, see Product Licensing (for Patch Manager) and License Orion Platform products in the Orion Web Console.

  1. Log in to the Orion Web Console as an administrator.
  2. Click Settings > All Settings.
  3. Under Product Specific Settings, click Patch Manager Settings.
  4. In the Patch Manager Settings page under Global Settings, click License Summary.

  5. Locate your product license details.

    For example, the SolarWinds NCM license on the Orion server is an evaluation license that is valid for 89 days.