Domain\user does not have access to the Analysis Services Tutorial database, or the database does not exist.
Posted on 2008-06-12
I'm an absolute newbie to Microsoft SQL Server 2005, and I'm trying to work my way through the Analysis Services Tutorial. I've got as far as "Reviewing Cube and Dimension Properties" in Lesson 2 "Defining and Deploying a Cube", but when I click on the Adventure Works DW cube in the Source Explorer and then click the Browse tab, I get the following error message:
Either the user, DSI\tipperp, does not have access to the Analysis Services Tutorial database, or the database does not exist.
I've tried launching Server Management Studio, right clicking on the AdventureWorksDW database, clicking Properties, Permissions, Add User or Role, but when I try to enter my domain\userid combination (dsi\tipperp), it doesn't recognise it as a valid object.
Can someone please explain how I can resolve this problem? Bear in mind I've next to no experience in SQL Server 2005.