Data Connections Management

The Data Connections View is a centralized place from which you can manage the connection strings of the reports' data sources. In this way by using a named connection string you can easily change the location of the database without actually modifying the report definitions.

The data connections view provides the following functions:

  • Search by Name, Data Provider or Connection String. For more information, see Search

  • Add a data connection

A new data connection is defined by a name, a description, a data provider and a connection string.

In order to read, write, or modify connection strings from the Report Server or from the Standalone Report Designer, the user must have permissions for the Data Connections View or they must be assigned the corresponding role - see User Roles.

Data connections with duplicate names are not allowed.

  • Edit a data connection
    The properties of an existing data connection can be modified at any time.
  • Delete a data connection
    You can delete an existing data connection when it is not used any more.
  • Copy a data connection
    To create a similar to an existing connection you can simply copy the source connection and modify its properties.