SSAS Cubes Failed after deployment

  • I was working on cubes and it kept failing after deployment with error:

    OLE DB error: OLE DB or ODBC error: Login failed for user 'mydomain\username$'.; 28000. 0 0

    I changed the datasource to use "specific user name and password" in impersonation information, it worked but created the database in my Local instance of sql server. I am using SQL Server 2008 R2. Anyone with such experience guys? Thanks for the help.

  • Did the deployment fail or are you getting the error trying to connect to the cube after deployment? Need a little more information in order to be helpful. Are you using visual studio 2008 to create the cube? How are you trying to deploy the cube? How are you trying to connect to the cube?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply