howto Install Sample Analysis Services Database

howto Install Sample Analysis Services Database

Postby stephen » Thu Oct 30, 2008 6:26 am

Problem:
When I try to browse the Analysis Services Tutorial Database from the Microsoft Visual Studio I receive this error:-
Either the user, PC-NAME\username, does not have access to the Analysis Services Tutorial Database, or the databasee does not exist.

When I use Microsoft SQL Server Management Studio and Open the Microsoft Analysis Server and check under databases there is no databases showing.
Solution:
Hint 1
Code: Select all
You have not mentioned deploying and processing the database. You need to perform these steps before you can browse the data.

from here
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2343909&SiteID=17

To Deploy the Database
http://sqldb.wordpress.com/2006/06/23/deploying-an-analysis-services-database-into-the-production-environment/
To run the Analysis Services Deployment Wizard interactively

* Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Analysis Services, and then click Deployment Wizard


I found the Adventure Works database here
Code: Select all
C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Tutorials\Lesson4\Analysis Services Tutorial\bin\Analysis Services Tutorial.asdatabase


Connection String:
Code: Select all
[Native OLE DB]Provider=SQLNCLI.1;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to SQL Server Help

Who is online

Users browsing this forum: No registered users and 2 guests

cron