Hello,
I'm attempting to use the Analysis Services. I've successfully set up and tested the connection string but get this error:

TITLE: Microsoft Report Designer
------------------------------

A connection cannot be made to the database.
Set and test the connection string.


------------------------------
ADDITIONAL INFORMATION:

Either the user, Harrison\nick, does not have access to the AdventureWorksDW database, or the database does not exist. (Microsoft SQL Server 2005 Analysis Services)

Any ideas where I should look to straighten this out?