Changing database configuration settings step -1

Use this step to :

  • Change the authentication type to connect to the SQL Server database.
  • Change the name of the server on which databases are setup.
  • Change the account credentials (user name & password) to connect to the SQL Server database.

To change the database configuration:

  1. Select the appropriate authentication type, that is, SQL Server Authentication or Windows Authentication.
  2. Select the Change Server Name check box to change the server name. Selecting the check box switches this option into the edit mode and allows you to type the new server name.
  3. Select the User Name and Password check box if you want to change the database account credentials. Selecting the box switches this option into the edit mode and allows you to change the user name and password.
  4. Click Update to change the database configuration.
    Note: The database account must have roles in the SQL Server as required by the applications, to connect to the database and execute the operations.
    Note: In case of Windows Authentication, the database account cannot be changed. For this type of authentication, the account set up for services account has access to the database and roles required to connect to the database and execute the operations.

    In addition to these steps, update this information in the Reporting Server (MSSSRS) to ensure that the report server is able to connect to the database to fetch data for the reports:

    On the Update Report Configuration (MSSSRS) screen, make the appropriate changes, if required. Click Update irrespective of whether any changes are made on that screen. The Information panel displays a connection string which must be set for the data source of the Reporting Server.

    Follow these steps to update the connection string provided in the Information panel:

    1. Go to
      • SQL Server Reporting Services > InforRisk&Compliance DataSources > CoreDB for IRC.
      • Home > CertificationManager > CMReports_ > CMDBName > CoreDB for Certification Manager.
    2. Replace the string in the Connection String text box with the connection string displayed in the Information panel of Report Config Settings (MSSSRS) screen. Click Apply.