Configuring and Maintaining CA SRM Web Reporter › CA SRM Web Reporter Control Panel › Connect to the Central Database

Connect to the Central Database

The Web Reporter Control Panel allows you to connect to the central SQL Server database.

To log in to the SQL Server

1. Open SRM Web Reporter Control Panel.
2. Click File, Connect to the Central DB.

   If you have previously connected to the central database, you are now connected and do not need to continue with Steps 3 and 4.

   If this is the first time connection, then Central Database Login Credentials below dialog appears.

   

3. Select appropriate authentication mode from Connect to Server dialog.

   SQL Server Name

   The SQL Server name will be picked by Web Reporter Control Panel by default and you will not be able to edit this field.

   Authentication

   Select an authentication mode.

   As a prerequisite system requirement, CA SRM Web Reporter uses MS SQL Server as its Central Database. Based on how it was installed, MS SQL Server is configured in one of two modes:

   • Windows authentication
   • SQL authentication

   CA SRM Web Reporter supports both modes.

   For more information, see the section Authentication Modes and SQL Connections.

   Note: If you select Windows Authentication, you cannot edit the user name and SQL Server username and password fields.

   User name/Password

   If you select SQL Server Authentication, then provide username and password.

4. Click Connect.