Create a data source for the report model.
Follow these steps.
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.
dialog for the Data Source Wizard appears, click the
Add a new Connection by clicking the New...
button in the
Select how to define the
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
The SQL Server name is commonly
the SQL Server service name MSSQLSERVERthey are not the same. The
appears in the
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
Specify the name of your SQL Server in place of
<SQL Server Name>
drop-down list and
as shown in the following figure.
Figure 6-2. Data Source Wizard:
Test the connection by clicking the
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.
button on the
to define the connection
Completing the Wizard
to create the new data source and end the wizard.