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