PMC Reporting Tab

Select I have already created the Reporting database if someone in your organization has created the Reporting database and you want the wizard to configure the connection to PMC, or select I do not want to configure Reporting if you do not intend to use Reporting with PMC.

The SQL Hostname, SQL Instance, SQL Database, and SQL Port that you provide are validated at this stage.

If there is no named instance, the default instance name of MSSQLSERVER should be used.

To configure the connection to the Privilege Management Reporting database:

  1. Enter the SQL Hostname, Instance, and Port number. If the instance is not the default instance you need to find the port number for your named instance and enter it here.

For more information, please see Obtain the SQL Port for a Specific Instance.

Choose 'I have already created the Reporting database' option to configure reporting. You must have installed the Privilege Management Reporting database as a prerequisite to use this option. If not using reporting, select 'I do not want to configure Reporting', at the bottom of the tab.

  1. Choose from SQL authentication or Windows authentication and enter the credentials of the user that you created in the prerequisites. If your deployment is non-domain-joined, you must use SQL authentication. This user manages the authentication of the Privilege Management Reporting database with the PMC application services.

 

The PMC deployment wizard needs a user with the dbo.owner permission to configure Reporting for PMC. After the installation completes, the user permissions can be reduced to dbo_datareader, db_datawriter, and execute.

The following script demotes the user. Replace myusername with your username.

EXECUTE sp_addrolemember 'db_datareader', 'myusername'
EXECUTE sp_addrolemember 'db_datawriter', 'myusername'
GRANT EXECUTE ON SCHEMA::dbo TO [myusername]
EXECUTE sp_droprolemember 'db_owner', 'myusername'

Obtain the SQL Port for a Specific Instance

To obtain the SQL instance port number:

  1. Open the SQL Server Configuration Manager.
  2. From the left menu, navigate to SQL Server Network Configuration > Protocols for "Instance Name".
  3. In the right panel, right-click on TCP/IP and scroll down to the last section, called IPAll. The port number is listed to the right of TCP Dynamic Ports.

Click Next to proceed to the PMC Portal Tab.

For more information, please see PMC Portal Tab.