None of the above solutions is working for me.

I too get the error, as below, when I try to deploy the standard 'Adventure Works DW 2008R2'

"Error 22 OLE DB error: OLE DB or ODBC error: Login failed for user '<username>' .; 28000; Cannot open database "AdventureWorksDW2008R2" requested by the login. The login failed.; 42000"

I downloaded the 'Adventure Works DW 2008R2.abf' and installed via SSMS by connecting to an analysis services server instance and doing a database restore.

I copied the .abf file to

C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup

and restored the database from there and called it 'AdventureWorksDW2008R2'. That was all fine.

So, once the database was restored to my analysis server this was the view in SSMS. See attached SSMS - SSAS AW Db image.bmp.

I then created an Analysis Services project in BIDS, by importing an existing SQL Server Analysis Services database (namely AdventureWorksDW2008R2). The wizard completed without errors.

I then do a deploy of the project and get 20 Warnings and 14 errors and the deploy failed.

The impersonation information is set to my username and password. I am an administrator on the server.

If I go to 'connection manager' the server name defaults to localhost and the 'connect to a database name' defaults to a list of databases within the local database engine, which does not include 'AdventureWorksDW2008R2' as this database resides within the Microsoft Analysis Server only.

Both the Microsoft Analysis Server and the Microsoft database engine are local and I have sysadmin rights on the engine too.

I dont have an 'NT AUTHORITY\NETWORK SERVICE' login user. I do have a NT AUTHORITY\SYSTEM and this login has the sysadmin role and makes no difference either.

SQL Server Analysis Services (MSSQLSERVER) via Services.msc is running as me too - no problem.

The only services that are not running is SQL Server Agent (MSSQLSERVER) and SQL Server Browser. The agent I have the rights to start but the browser I don't. I haven't attempted to start either as I have had no indication that they would have any effect.

This is a very frustrating problem as it means you cant use the product at all. I have been trying fix it for 2 days now. Grrr!

Please someone enlighten me.