MS SQL Reporting Services

[nemaroller]

mendhank,

I remember Reporting Services had a configuration file... but its been about 2 months since we dropped them and moved to ActiveReports...

It was a bear to get RS to do the things we wanted it to do... and we spent 2 weeks with MS to only produce a hack work around (which was amazing, so there are real smart guys at ms), but our clients wouldn't have liked it.

"This section provides information about system security settings that are in effect for a report server. Reporting Services uses Internet Information Services (IIS) and Windows security to authenticate users to a report server. Each user who requires access to a report server must have a valid Windows user account or be a member of a Windows group account. You can include accounts from other domains as long as those domains are trusted. The accounts must have access to the Web server hosting the report server, and must be subsequently assigned to roles in order to gain access to specific report server operations. For more information about role-based access, see Using Role Based-Security .

Trusted and single domains are a requirement for passing Windows credentials. Unlimited passing of credentials only occurs if you enable Kerberos V5 for your servers. If Kerberos is not enabled, credentials can only be passed once before they expire. For more information about configuring credentials for multiple computer connections, see Best Practices for Authenticating Server and Data Source Connections.
"