Deployment Considerations for Server Reports

Article
07/13/2009

All users who run your application and require access to a report must have permission to access the report server. The client application must connect to the SQL Server 2005 Reporting Services report server. The client application must provide the security identity of the user who will view the reports. Alternatively, you can provide a single set of credentials that all users use.

Deployment Considerations for Server Reports

Applications that include reports that are stored on a report server must provide a valid URL for a remote SQL Server 2005 Reporting Services instance and path information to the report. You can specify the reference in the ReportViewer Tasks smart tags panel when you add the control to a form or Web page. You can also specify this information programmatically if the server location is unknown at design time.

Connecting to the Report Server

If you are deploying a server report, the ReportViewer control connects to the report server as the thread user. If the thread user is not authorized to view the report, you must supply a IReportServerCredentials object to the ReportViewer Web server control. This object provides credentials used to connect to the server. If you are using the ReportViewer Windows Forms control, use the ReportServerCredentials property on the ServerReport object.

ASP.NET deployment introduces additional considerations. If ASP.NET is not configured for impersonation, you will need to develop a strategy for user access to computers and data sources.

For more information, see Specifying Connections and Credentials for the ReportViewer Web Server Control.

Connecting to External Data Sources

In Reporting Services, reports that are published to a report server may retrieve data from external servers. To retrieve data from those servers, users may be prompted to provide a user name and account. Whether a user is prompted for credentials depends on how data source properties are configured for the report. Reports can be configured to use stored credentials, integrated security, prompted credentials, or no credentials. If you include a report that uses integrated security, all users who require access to the report must have access to the data source used by the report. For more information, see "Specifying Credential and Connection Information" and "Managing Data Source Connections" in SQL Server 2005 Books Online.

Share via

Deployment Considerations for Server Reports