Select the Data Source (Report Wizard)

Use this page of the Report Wizard to define a data source for the report.

Options

Shared data source
Select Shared Data Source to use a predefined shared data source that already has the data source connection information you want to use. The list contains all shared data sources that are included in the project.

New data source
Select New data source to define a new data source. The data source information will be used only with the current report.

Name
Type the name of the data source. The data source name must be unique within the report.

Type
Select a data processing extension. The data processing extension you choose must correspond to the type of data source you are using (for example, if you are using a SQL Server database, choose the Microsoft SQL Server data processing extension). Data processing extensions are part of Reporting Services. They are used on the report server to connect to a data source and process query results, and in Report Designer when you specify a data source for a report. The list displays all registered extensions. Settings in the Report Designer configuration file determines extension registration.

Connection string
Type a connection string for the data source. For more information about connect strings, see Connecting to a Data Source.

Click Edit to specify the data source server using the Connection Properties dialog box. You can specify a local or remote data source.

Click Credentials to supply database credentials. At a minimum, the credentials you specify must be sufficient for you to connect to the data source for report design purposes. When the report is deployed on a report server, the database credentials must accommodate all users of the report. For example, if you want all report users to connect to the data source using their credentials, choose Windows authentication (integrated security). The credentials you specify must be valid for the data source, so if you choose Windows authentication, be sure that the data source accepts connections from all user accounts that will be running the report. Database credentials can be managed separately from the report. For more information, see Setting Data Source Properties in Reporting Services.

Make this a shared data source
Select this option to store the data source in the project as a shared data source, instead of in the report.