Microsoft SQL Server 2005 Reporting Services, 2nd Edition

12.2. Custom Security

Another way to customize Reporting Services is through its security extension. By default, Reporting Services uses Windows integrated security. As you have seen, this means a user must have valid credentials (a user name and password) for either a local logon on the Report Server or for a domain logon on the domain containing the Report Server.

There are times, however, when creating Windows credentials for each Reporting Services user is not desirable or even feasible. You may want to expose reports on an Internet site or an extranet site. You may want to use the Report Manager as part of a web application that makes use of a different security model, such as forms authentication. In these situations, you can consider ...