Impersonation error when processing a cube (related to SSAS)

When you build and deploy the Cube (in Business Intelligence Development Studio, now superseded by SQL Server Data Tools), the next step is to process the Cube.

I ran into an error which went similar to this : “A connection could not be made to the datasource with the DataSourceID of xxxx.”

The problem is well known and simple to resolve. When we first create the Data Source, we must specify the Impersonation option. I had given it as “Inherit”. However, this fails as this cant login to the Analysis Server database.

The solution is to give a more privileged user (depending on your security settings). For me, I could give the Windows login that connects to my SQL Server here. Therefore in the Design View of BIDS, right click your Data Source in Solution Explorer and choose Open. In the “Impersonation Information” tab, pls give the username/password in “Use a specific Windows username and password”. Now rebuild, deploy and process the cube.

I hope this helps. Pls let me know if there are any doubts.

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s