sql server reporting services: Security -- sql server reporting services

Security

Joe
10/17/2006 2:07:58 PM

sql server reporting services: Having problems with getting security to work right. Want NT security to
work.

Scenario - I create a report and DS and deploy it with Windows Integrated
Security - but for some reason it only let's me view it and not other foks
that are in same role as me. In fact, I can only get reports to work where
others can execute them only if i select 'Credentials stored securely in the
report server' and put in either my NT credentials or a SQL logon.

What am I doing wrong?

Re: Security

Kaisa M. Lindahl Lervik
10/18/2006 4:11:41 PM

How is the Report Manager virtual directory set up in IIS? Does it allow
Anonymous Logon? If it does, turn it off so you have to authenticate to
access the reports.

Also, make sure that the other users are actually sending their credentials
through the browser. Check Security Settings under Internet Options. If you
only send credentials to sites in Intranet Sites, make sure your report site
is in the list of Intranet SItes. Or add it to trusted sites, and change the
way you send the credentials to also send them to Trusted sites.

Kaisa M. Lindahl Lervik

[quoted text, click to view]