SSAS Credential Issue when Generating OLAP

By - Nov 13, 2013

Symptom

If an error is show as below at deploy time, this indicates that SSAS credential (CORP\ssas_si) does not have SQL Server Administrator permission.

Resolution

1. Open SQL Server Management Studio. Check if the user has a Login or not. If yes, double click the user and jump to Step 3).

2. Create a Login for the user.

3. In the Server Roles tab, add the user as a sysadmin. Then save your change.

4. Now you should be able to deploy the application successfully.

 


Facebooktwitterlinkedinmail