Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / August 2008

Tip: Looking for answers? Try searching our database.

Resource for configuring SSRS with IIS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt - 27 Aug 2008 14:53 GMT
Can anyone recommend a good book or other resource with *detail* on
configuring permissions in IIS with Reporting Services 2005? I am finding
bits and pieces online but there doesn't seem to be a single decent in depth
resource that explains what changes need to be done to IIS to get it working
with SSRS etc. For example folder permissions in the IIS site and on the SQL
Servers C Drive.

Thanks
Bruce L-C  [MVP] - 27 Aug 2008 15:37 GMT
If you can go with RS 2008 they totally do away with using IIS. Precisely
because IIS is such a huge support burden.

One mistake I think you are making is touching IIS directly. I never, ever
touch IIS. I installed RS which added its websites to IIS. I then use RS
role based security for all security and I let RS handle everything. You
should not ever have to touch IIS directly. I have used RS since the Beta
for RS 2000 and I never have had to do anything with IIS other than stop and
restart it (some problems with RS 2000 when it came out). With RS 2005 I
never ever deal with IIS at all. It just works.

You say folder permissions in the IIS site and the SQL Servers C drive.
Again, do not touch this. The only time any folder permissions I have seen
need to be touched is when dealing with Oracle data providers. Otherwise,
again, no need to do so. Use Report Manager to control permissions.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Can anyone recommend a good book or other resource with *detail* on
> configuring permissions in IIS with Reporting Services 2005? I am finding
[quoted text clipped - 7 lines]
>
> Thanks
Matt - 28 Aug 2008 09:01 GMT
Thanks Bruce - that explains why I wasn't able to find much info. My own
knowledge of IIS goes way back so I think I got a little confused. I am
tempted to reinstall both IIS and RS on the server as they aren't in use for
anything else and go with a vanilla install to see what happens.

regards, Matt

> If you can go with RS 2008 they totally do away with using IIS. Precisely
> because IIS is such a huge support burden.
[quoted text clipped - 23 lines]
> >
> > Thanks
Bruce L-C  [MVP] - 28 Aug 2008 13:57 GMT
That is best. Let RS handle everything and it will go totally smoothly.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Thanks Bruce - that explains why I wasn't able to find much info. My own
> knowledge of IIS goes way back so I think I got a little confused. I am
[quoted text clipped - 36 lines]
>> >
>> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.