Reporting Services Report Models - Professional SQL Server 2005 Reporting Services - page 343

Figure 8-2
When adding a new data source, the Data Source Wizard is initiated. This wizard will step you through
the creation of a SQL Server connection. After moving past the welcome screen, select the New... button
to open the Connection Manager window. Figures 8-3 and 8-4 walk you through creating a new connec-
tion to the AdventureWorksDW database.
Figure 8-3
Once you have set up the new connection, continue through the Data Source Wizard by clicking Next.
The final screen of the wizard will let you assign a name to your data source. In this scenario, you can
leave the default name “Adventure Works DW” and click Finish, as shown in Figure 8-5.
The Connection Manager and Data Source Wizard are now common components used throughout pro-
jects in the Business Intelligence Studio. Once you have created a Connection Manager, it will be avail-
able for use in Analysis Services and Integration Services projects.
Now that the data source has been created, you can move on to creating the Data Source View.