Previous Topic: Modify the Microsoft SQL Server Database Connectivity SettingsNext Topic: How to Configure the Report Portal to Work in Windows Authentication


Windows Authentication Configuration For the Report Portal

Valid on Windows

When you install the Report Portal (CA Business Intelligence) and select to use Microsoft SQL Server as the CMS database, the authentication mode is set to SQL Server Authentication. Microsoft SQL Server authentication uses a SQL user account to authenticate database connections.

If Active Directory is used in your organization, you can modify the authentication method to Windows Authentication. In Windows Authentication, connections to the CMS database are authenticated using a Domain user account and not a local user account.

Authenticating connection in Windows Authentication provides a secured method of communication between all Report Portal components. You can remove clear text passwords from the report packages you deploy on the Report Portal because you configure an ODBC connection to the database that contains the user credentials.

Important! Windows Authentication requires that you use both Internet Information Server (IIS) and Microsoft SQL Server.