Adventure Works DW databases INSTALLATION

In SQL Server April 2006 Books Online (BOL)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm

... near the bottom, the following is said ...

To deploy the Adventure Works DW analysis services project

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.

Where do I install/find the "Adventure Works DW database?" I can not find this other database anywhere?

Thanks.

AIM

During product installation make sure you install Samples.

After product is installed go to the Start->Programs->Microsoft SQL Server 2005->Documentation and Tutorials->Samples and run Setup for "Microsoft SQL Server 2005 Samples (English)"

You AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples. There you would also find relational database for it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hi,

We can also install the default database in another way right from the very beginning. When we are installing the MSAS2005 After selecting the components that we want to install and click on the Advance button. Select "Entire feature will be installed on local hard drive" for the "Books Online and Samples" category.

Your AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples

Please let me know if I am wrong

Thanks

|||

I have been sending forum questions about setting up the Analysis services samples.

I finally figured this out: "Adventure Works DB" database and "AdventureWorksDW" are the same.

In the Analysis Services sample solution "Adventure Works DW," I was recieving Process errors on cubes. I right clicked the solution. I chose properties. I changed the database from Adventure Works DW (that does not exist) AdventureWorksDW. Next, I processed and did not get any errors.

This is from the latest April Samples collection. Maybe someone can tell the people at Microsoft to make this fix.

AIMDBA

sql