SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000

SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000

I was trying to deploy my AdventureWorksDW2012 Cube Sample  and got interesting error as below

OLE DB error: OLE DB or ODBC error: Login failed for user ‘MYDOMAIN\MYSERVER$’.; 28000

If you receive above error most likely your SSAS Instance running under account which doesn’t have permission to read SQL Server Database referenced by your cubes. So you have two options here

Option-1: Change SSAS Service account to something else which has proper permissions to read sql server database.

Or

Option-2:Add SSAS Service account as login under sql server and give proper permissions to read databases which are needed to build cubes properly.

To change service account for SQL Server or SSAS Service goto
Start > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager

Once configuration manager is loaded click on Services

sql-server-configuration-manager-change-account-1

To change service account right click on desired service and click properties

sql-server-configuration-manager-change-service-account-2

 

Once you do this you should be Golden!!!

 

Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.