Export (0) Print
Expand All
Expand Minimize

How to: Configure a Report-Specific Data Source (Management Studio)

SQL Server 2005

  1. In Object Explorer, expand a report server node.

  2. Expand the Home folder, and navigate to the folder containing the report you want to configure a data source for. Expand the report item.

  3. Expand the Data Sources folder.

  4. Right-click the data source item that you want to configure, and click Properties. The General page of the Report Data Source Properties dialog box is displayed.

    ms159658.note(en-US,SQL.90).gifNote:
    If A shared data source is selected, you have opened a report that uses a shared data source for the data source connection. You cannot configure the connection string or credentials for the shared data source from this dialog box. Navigate to the shared data source in Object Explorer to configure the credentials. For more information about configuring credentials, see How to: Create, Delete, or Modify a Shared Data Source (Management Studio).

  5. Select A custom data source. Several options are displayed.

  6. Select the data source type from the list.

  7. Type the connection string that the report server uses to connect to the data source. The following example illustrates a connection string used to connect to the SQL Server AdventureWorks database:

    data source=<localservername>;initial catalog=AdventureWorks
    
  8. For Connect using, specify how credentials are obtained when the report runs as follows:

    • If you want to prompt the user for a logon name and password, click The credentials supplied by the user running the report.
    • If you intend to use the data source with reports that support subscriptions or other scheduled operations (such as automated report history generation), click Credentials stored securely in the report server.
    • If you want the report server to pass the credentials of the user accessing the report to the server hosting the external data source, click Windows Integrated Security. In this case, the user is not prompted to type a user name or password.
    • If none of the above apply, click Credentials are not required. To use this setting, the report server must be configured to use an unattended processing account. For more information, see Configuring an Account for Unattended Report Processing.
  9. Click OK.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft