sql server connection string persist security info

The (default) option represents the CMSConnectionString added by the application's initial database installation. The setting loads the list of connection strings from the web.config and displays their name attribute values.

Add a new connection string into the section.Įnter authentication information (the user id and password) for the appropriate database user account.

Edit your administration application's web.config file.

Prepare a user account for your database with the required security configuration.You can restrict the database-level permissions of the SQL queries used for reporting by registering custom connection strings and assigning them to reports. Specifying connection strings for reports

The report uses the specified connection string to access the database when loading data. Subscription also needs to be allowed for individual reports through their properties.Īllows users to change the connection string property of reports and their components. This permission is needed to create new reports, but it can be a security risk, since it allows users to run queries against the system's database.Īllows users to subscribe to reports and their components. This also grants permission to subscribe to reports.Īllows users to delete the version history of reporting objects.Īllows editing of the queries used to retrieve data for reporting components (graphs, tables and values). Allows users to save reports into the report archive.Īllows users to create, modify and delete reports.

Sql server connection string persist security info