sql-server-2012ssascubebidssql-server-2012-datatools

SQL SSAS Cube Deploy Error:

I am trying to deploy a cube I created in SQL Server Data Tool using AdventureWorksDW2008R2, I used windows authentication login the database engine with all permissions granted to it. and yet I still get these arrors in the picture below when deploying the cube. Anyone Can point out which part is wrong here?

enter image description here

Solution

  • May I know which option in the Data Source designer did you choose before deployment?

    Note that based on the page below, even if your account has access to the database, you cannot use ImpersonateCurrentUser option.

    https://msdn.microsoft.com/en-us/library/ms189027.aspx

    Have you tried using the "Use a specific username and password" and entering the login details?