Implementation Guide › Changing Communication Encryption Methods › Windows Authentication Configuration For the Report Portal › How to Configure the Report Portal to Work in Windows Authentication › System DSN Connection Configuration Example

System DSN Connection Configuration Example

System DSN connection settings define the parameters needed to connect to a database. In the following example, you create a system DSN that authenticates users connection in SQL Server Authentication, because the Report Portal only supports SQL Authentication when it is installed. You configure the CMS database system DSN before you install CA Business Intelligence.

In the following example, you create a System DSN for the Report Portal CMS database:

1. Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC).

   The ODBC Data Sources Administrator opens.

2. From the System DSN tab, select Create.

   The Select a New Data Source window opens.

3. Scroll down and select SQL Server, then click Finish.

   The Create a New Data Source to SQL Server wizard opens.

4. Enter the connection name, description and SQL server name. Click Next.
5. Select to use SQL Server Authentication.
6. Enter the administrator user credentials to connect to the SQL server. Click Next.
7. Select the Change the default database to option and select the Report Portal CMS database from the list. Click Next.
8. Click Finish. Select to test the connection, then click OK.

   The System DSN is created.