Galactic Data Model

Question

I am trying to do the examples using SQL Server 2005 Reporting Services (2006) by Brian Larson.

The example says to use GDS as the data source yet all I see is Adventure Works.

The tables for AW are not the same as the tables for GDS.

 

Is there something I need to do or does the DBA need to install something else.

Answer 1

Have you installed the Galactic database yet from the downloaded source code for the book? If not, run the 'Create Galactic Database.sql' script in the 'Galactic Database Install' folder. At the bottom of the script is the userid and password:

exec sp_addlogin N'GalacticReporting', N'gds', @logindb, @loginlang

 

In order to set up the data source, you must use this userid and password (unless you change it to something more convenient). See if that works for you and hollar if it doesn't.