Advertisement

06.12.2008 at 01:33AM PDT, ID: 23478638
[x]
Attachment Details

Domain\user does not have access to the Analysis Services Tutorial database, or the database does not exist.

Asked by paul_tipper in SQL Server 2005, MS SQL Server, OLAP

Tags: Microsoft, SQL Server, 2005, Business Intelligence Development Studo

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.Start Free Trial
[+][-]06.12.2008 at 01:36AM PDT, ID: 21767214

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 03:41AM PDT, ID: 21767925

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 11:54AM PDT, ID: 21796329

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 12:02PM PDT, ID: 21796394

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2008 at 02:31AM PDT, ID: 21801160

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2008 at 02:33AM PDT, ID: 21801172

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2008 at 02:40AM PDT, ID: 21801204

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.19.2008 at 03:18AM PDT, ID: 21820762

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 12:17PM PDT, ID: 21841828

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.23.2008 at 01:08AM PDT, ID: 21844289

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.23.2008 at 01:14AM PDT, ID: 21844316

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.23.2008 at 02:09AM PDT, ID: 21844528

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.23.2008 at 02:42AM PDT, ID: 21844635

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.23.2008 at 03:25AM PDT, ID: 21844794

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server, OLAP
Tags: Microsoft, SQL Server, 2005, Business Intelligence Development Studo
Sign Up Now!
Solution Provided By: srnar
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.23.2008 at 04:11AM PDT, ID: 21845006

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628