daveed


Hi,

Can anyone help with a problem I have with the Microsoft SQL Server 2005 Analysis Services Step by Step guide. I am trying to connect to the SSAS Step by Step DW database but this database doers not appear in the Databases folder in Management Studio, even though I have connected to the Database Engine as specified in chapter 3 of the guide.




Re: SSAS Step by Step - Missing Database

Yan


Hi Daveed,

Try reinstall the sample databases and go through it again.

Yan






Re: SSAS Step by Step - Missing Database

Marcus Ghelli

Hi David, the SSAS DW DataBase

come with the Book's CD

You will find the MDF File in this Folder :

C:\Documents and Settings\<USER>\My Documents\Microsoft Press\AS2005SBS\Setup\Database







Re: SSAS Step by Step - Missing Database

AndySc

HI Daveed,

You have to complete step 5 on page xii, a command from start>run that will restore the databases from the sample data folders to the sql server.

best,

Andy






Re: SSAS Step by Step - Missing Database

evajen01

Hi,

I'm not sure if anyone else was having this problem, but the cmd specified on page xii was not attaching the database to my local instance of sql server. I had to attach it manually, by right-clicking Databases in SSMS and choosing Attach. I navigated out to the .mdf file using the link specified above. However, I kept receiving an error because the log file could not be found. After spending some time unsucessfully looking for the .ldf log file, I chose the log file specified in the Attach Databases dialog, and clicked Remove. This seemed to work, as I was then able to attach the database and perform the remaining steps in Chapter 3.

Sincerely,

Eric






Re: SSAS Step by Step - Missing Database

Buncle

Hi

Thanks Eric for that info it worked fine for me, I had been going round in circles with this one and as usual no constructive help on Microsoft support site or on the web apart from your welcome nugget!!

Regards

Buncle





Re: SSAS Step by Step - Missing Database

KOTESWARA RAO1

could you please send me Microsoft SQL Server 2005 Analysis Services Step by Step DW database