Section 6.1. Create a Data Source

6.1. Create a Data Source

Create a data source for the report model. Follow these steps.

1. Right-click the Data Sources node in the Solution Explorer pane. Select Add New Data Source from the context menu to start the Data Source Wizard.

2. If the Welcome dialog for the Data Source Wizard appears, click the Next > button.

3. Add a new Connection by clicking the New... button in the Select how to define the connection dialog shown in the following figure.

   Figure 6-1. Data Source Wizard: Select How to Define the Connection

   

   Clicking the New... button opens the Connection Manager dialog.

   NOTE

   The SQL Server name is commonly confused with the SQL Server service name MSSQLSERVERthey are not the same. The SQL server name appears in the Connect To Server dialog that appears when you start SQL Server Management Studio and as the value for the Name attribute in the property page for the server node in Object Explorer in SQL Server Management Studio.

4. Specify the name of your SQL Server in place of <SQL Server Name> in the Server name drop-down list and select the AdventureWorks database as shown in the following figure.

   Figure 6-2. Data Source Wizard: Connection Manager

   

   Test the connection by clicking the Test button.

   Press the Close button to create the connection and return to the Data Source Wizard dialog, which now displays the new connection in the Data Connections list box.

5. Click the Finish >> button on the Select how to define the connection dialog.

6. Click Finish on the Completing the Wizard dialog to create the new data source and end the wizard.

The new data source Adventure Works.ds appears in the Solution Explorer pane under the Data Sources node.