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.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-04-14 : 11:10:02
|
 Hi guys,My users are unable to view reports on server A. When trying to access it shows up as users have no access to the reports.We have another server B which also deploys the same set of reports,to the same set of users as Server A.Users are able to view the reports on Server B.Both server B & A are used for deploying reports that are created on another development server.I am very new to the concepts of IIS and report administration.Could someone tell me what I can start checking on? What are the settings that I can compare on both server ?If I am not very clear on the problem explained above.Do let me know I would be glad to explain futher. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 22:47:29
|
| Compare user permissions in ssrs on both servers. |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-04-15 : 08:49:42
|
| After futher investigation here is what I found, when user tries to access reports on ServerA, a pop up appears asking them to key in their user name and password.This does not happend when they try to access reports on ServerB.How do I overcome this problem ?Hi rmiao,Do I need to go into Mngt Studio Connect to Reporting Services and then Security Folder Or Do I go and check in Mngt Studio> Database Engine> Report Server db OR Mngt Studio >Security tab?Am I missing on anything else ? Thank You In advance |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-15 : 22:30:39
|
| Should check in Mngt Studio Connect to Reporting Services and then Security Folder. |
|
|
|
elracorey
Starting Member
30 Posts |
Posted - 2008-05-09 : 06:05:28
|
| I set up a special secure user/password for SSRS via the SSRS Config screen, then set the user up in SQL Server 2005 accordingly. With regards to IIS, I find that IIS 6 is more tricky than 5.1. I ended up giving Domain Admin permission to my IUSR_ user as people outside of my domain couldn't access the reports. |
|
|
|
|
|
|
Prompt user for user name and password