Connect to an external SSAS server
- Thijs Froon
In some cases, a connector is used to access data in a source that is located in a different domain then the CXO application server is located in. To create the connection to an external SSAS server, the domain credentials need to be stored on the application server in a way that these can be used by the service account that is running the CXO services.
Open the credential manager as a different user
Open a CMD window with the credentials of the CXO service account and run the command:
rundll32.exe keymgr.dll, KRShowKeyMgr
This will open the credential manager for the service account
Click on “Add“ to add a new Windows login credential rule
Fill in the target machine name where SSAS is hosted, Enter the domainname\username and the password of the account and click “OK“
Change the used user profile in IIS
The last step is to change the value for “Load User Profile“ for the CXO application pool to True.
Open IIS, drill down the website and open “Application Pools“
Right click the CXO application pool and select “Advanced Settings“
Change the value for “Load User Profile“ to True