SSAS SI Cannot Connect to Relational Database

Symptom

Deployment fails at the Process step, and the error reads: “The SSAS service identity (SSAS SI) cannot connect to the relation database due to insufficient permissions. Please review the required permissions for the SSAS SI as outlined in the Kepion installation guide."

This deployment issue is caused by one of the following errors: 

• Error code 28000: SSAS SI login is not registered to the SQL server.
• Error code 42000: SSAS SI login does not have database permissions.

Resolve error 28000

You will see error 28000 if you need to create an SSAS SI login and set its permissions.

1. Create the SSAS SI login.

2. Set server-level permissions for your SSAS SI.

3. Set database-level permissions for your SSAS SI. 

Resolve error 42000

You will see error 42000 if the SSAS SI login has been created but not granted dbreader permission to the target application database.

1. Verify that you have created the SSAS SI login.

2. Verify that you have set server-level permissions for your SSAS SI.

3. Set database-level permissions for your SSAS SI.