Single Sign-On to Microsoft Analysis Services

Strategy supports single sign-on authentication of a Windows user to MicroStrategy Developer, Strategy Web, and Microsoft Analysis Services serving as an MDX cube source in Strategy, using the integrated authentication option.

Integrated authentication enables a user to log in once to their network account, using Kerberos to validate the user's credentials, and access Strategy Web and Microsoft Analysis Services without having to log in again. With integrated authentication, Windows users' login credentials can also be used to execute against MDX cubes imported from Analysis Services into Strategy. To configure this type of authentication, see the Identifying Users: Authentication section of the System Administration Help.

To enable Kerberos authentication pass-through to Analysis Services, you must install the Strategy MDX Cube provider on the same machine with the Strategy Intelligence Server.

After you have enabled integrated authentication, you must allow access to Microsoft Analysis Services MDX cubes. To enable a Windows user access to these MDX cubes in Strategy, you must assign the Windows user membership to one or more Analysis Services security role definitions. For more information, see Connecting to Analysis Services Servers.