Home > 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