Skip Navigation LinksHome > SSW Standards > Rules > SSW Rules to Better Business Intelligence - Setting up Resources

There was an error displaying the testimonials. Please report this error to SSW and include the following text:
- A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 

Attaching the AdventureWorks2000DW Data Warehouse Database

In Enterprise Manager, right click Databases -> New Database...

Create a database with the name "AdventureWorks2000DW".

Refresh the Enterprise Manager view so that the new database is displayed. Right click the AdventureWorks2000DW database that you just created, and select All Tasks -> Restore Database...

In the Restore radio button group select "From Device", click Select Device. Click Add and select the file that you downloaded (and uncompressed) to restore the database.

Note: you will need to make sure there are no current connections to the database.

Bring in the AdventureWorks2000 Cube

In Analysis Manager, right click server -> Restore Database. Select the .cab file to create the Reseller Sales cube.

You might need to change the data source for the new cube, if you used an a different database name in the above steps. In the data source dialog reselect the appropriate table and configure any security information.

You might want to fix some of the properties of the cube. Check out http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterBusinessIntelligence.aspx for some rules that we think are important.

Acknowledgements

Andrew Weaver
Adam Cogan
Grant Paisley