How can users view reports without giving them my SQL Reporting Services password?

MS SQL 2008 Reporting Service:
Use the report viewer control.

MS SQL 2005 Reporting Service:
Use the report viewer control.

MS SQL 2000 Reporting Service:
Reports can be pulled directly from the SQL Reporting Server and rendered inside any web application through Reporting Service's Web Service Interface. To learn more about how to consume the web service, reference the Reporting Service help documents.

Article ID: 222, Created On: 11/14/2008, Modified: 5/25/2010