Report Server Virtual Directory:ReportServer
Report Manager Virtual Directory:Reports
IIS should have two virtual directories created: Reports and ReportServer.
SQL Server Management Studio should include two databases: ReportServer and ReportServerTempDB.
Creating a report
SQL Server Business Intelligence Development Studio(BIDS)
Following the wizard to create a base report: MyAddress;
Right-click on the MyAddress.rdl --Select "Deploy" --Close the BIDS;Report Manager: http://localhost/reports
Understanding the Data Source settings--when generating the report, a dialog box is popped up.
When "Use as Windows credentials when connecting to the data source" is checked, VIP\John, VIP\simon, and VIP\Administrator can be used. If it is cleared, the user:reportuser can be used. the reportuser is SQL server user.
When a report is scheduled (that means it is run unattendedly), you select "Credentials stored securely in the report server". What does "Impersonate the authenticated user after a connection has been made to the data source" mean?
You should understand the SETUSER command. It allows a member of the sysadmin fixed server role or db_owner fixed database role to impersonate another user. http://localhost/reports -->Creating a report with SELECT TOP 5 AddressLine1 FROM Person.Address; -->assign the report permissions as:
BUILTIN\Administrators:Content Manager
VIP\John:Browser
VIP\Simon:Browser
VIP\John has the SELECT permission on Person.Address table. In FireFox Browser address bar, type http://localhost/reports and logon as VIP\John. The user VIP\John can run the report.
VIP\Simon does not have the SELECT permission on Person.Address table. VIP\Simon cannot run the report even though the connection is made by VIP\Administrator.
You cannot ask VIP\Simon to impersonate the VIP\Administrator.
You must uncheck the "Impersonate the authenticated user after the connection has been made to the data source" when you run an unattended report creation, such as scheduled report creation.
