Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Restrict Access to SSRS Server

Author  Topic 

Alvin_SQL007
Starting Member

12 Posts

Posted - 2014-08-14 : 14:12:48
Hi All,

We are having a major issue with access to our SSRS Server. looks like users can simply click on a URL and access all the reports without entering a password. URL looks something like this "•http://Reports.OurCompanyName/reportserver". when they click on the URL, it prompts for User ID and PW but if users just enter the ID and leave the PW blank and click on Logon button they are still able to logon and are able to see HTML view of all the reports and are able to run the reports aswell. how can we change this? so that users can access only if they enter a PW?

BTW: if users enter an ID which does not have access to browse the report then they are not able to get to the files.

Please share any ideas or possible solutions that can fix this issue.

Many Thanks in advance.
   

- Advertisement -