Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSAS Cubes

Author  Topic 

GhantaBro
Posting Yak Master

215 Posts

Posted - 2010-08-31 : 08:18:46
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.
   

- Advertisement -