CHAPTER 3 INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLS
after deployment. In BIDS, shared data sources contain several properties that you must configure
before you can use them.
Let’s step through the process of creating the shared data source for the stored procedure
Emp_Svc_Cost. First, right-click Shared Data Sources in the Solution Explorer, and select Add New Data
Source; the Shared Data Source Properties dialog box will appear. Second, click the Edit button in the
dialog box to create the connection string. In this case, you know that the server that contains your
source database and stored procedure is located on the local SQL Server, so you can type localhost as
the server name. Because we left the default connection type on the previous window, the data source
property is set to Microsoft SQL Server (SqlClient). After you type localhost as the server, you can
choose the Pro_SSRS database from the database drop-down selection. In this case, because the database
is configured to use both Windows and SQL authentication, choose the Use Windows Authentication
option. If you choose to use SQL authentication, you can also choose to store the SQL username and
password. Generally, Windows Authentication is the preferred method because it has a single point of
login for users (Chapter 11 covers authentication for deployed reports). Figure 3-7 shows the data source
connection properties. You can test the connection by clicking the Test Connection button.Figure 3-7. Data source connection properties