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.