I am an absolute newbie at MS SQL Server 2005, and I'm trying to work my way through the Analysis Services Tutorial to get a feel for how BI works in SQL Server. First thing I noticed was that the AdventureWorks database that is used in the tutorial is NOT installed by default; I tried installing it from the disk, which failed, so I ended up downloading the .msi flles from the web and installing it that way.
Following the tutorial, I went about adding the AdventureWorks db as a data source. The db did not appear in the dropdown of available databases, so I typed in the name manually, which seemed to work. The next step required me to add AdventureWorks as a Data Source View, but when I try to do this, I get the following message:
TITLE: Microsoft SQL Native Client
Login failed for user 'DSI\tipperp'.
Cannot open database "AdventureWorksDW" requested by the login. The login failed.
Also, in the Server Management Studio, the AdventureWorks database does NOT appear in the list of available databases.
Can anyone suggest what I need to do to make AdventureWorks appear, and how I set access permissions to this database so I can log in to it using my domain name and password?