Steps to Implement Database Warehouse Authentication

The procedure below gives the high-level steps for configuring your Intelligence Server for database warehouse authentication.

High-Level Steps for Configuring Database Warehouse Authentication

1. Create a DSN and a database instance for the authentication database.
2. Configure the project source to allow anonymous authentication (see Implement Standard Authentication).
3. Configure the project source to use database warehouse authentication (see Configuring the Authentication Mode for a Project Source).
4. Assign a security role to the Public/Guest group for each project to which you want to provide access (see Defining Sets of Privileges: Security Roles).
5. Link each MicroStrategy user to an RDBMS user. In the User Editor, in the Authentication: Metadata category, type the data warehouse login ID in the Database Login field.

   You can create the MicroStrategy users by importing a list of the RDBMS users into the MicroStrategy system. For instructions, see Creating, Importing, and Deleting Users and Groups.

6. For each project, in the Project Configuration Editor, in the Database instances: Authentication: Metadata category, specify the database instance for the authentication database.
7. For each project, enable database execution using linked warehouse logins (see Linking Database Users and MicroStrategy Users: Passthrough Execution).
8. To enable database authentication in MicroStrategy Web, log in as an administrator. On the Preferences page, select Project Defaults. The Project Defaults page is displayed.
9. Under Security, select the Database Authentication check box, and then click Apply.