PMC Database Tab

If you have created the PMC management databases manually prior to starting this deployment, select I have already created the PMC databases.

If you want the PMC deployment wizard to create and configure the PMC management databases, select I want to create and configure the PMC databases automatically to allow the wizard to create and configure the PMC databases.

  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.
  2. Enter your SQL credentials; these need to have the SQL sysadmin permission. These credentials are used only to set up the PMC management database. They are not subsequently used by PMC, as authentication with the PMC management database is done using the credentials specified in the next section of the dialog.
  3. Choose from SQL authentication or Windows authentication and enter the credentials. If your deployment is non-domain-joined, you must use SQL authentication. This user manages the authentication of the PMC management database with the PMC application services. The wizard creates this user if it doesn’t already exist and assigns the db_datareader, db_datawriter, and execute permissions. You can only use Windows authentication in a domain-joined deployment.
  4. Click Next to proceed to the PMC Reporting tab.

The authentication you choose here is the same as the authentication for the PMC Reporting tab.

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 Reporting tab.

For more information, please see PMC Reporting Tab.