Resource for configuring SSRS with IIS

This is a discussion on Resource for configuring SSRS with IIS within the ms-sqlserver forums in Microsoft SQL Server category; 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...

Go Back   Database Forum > Microsoft SQL Server > ms-sqlserver

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-27-2008, 10:53 AM
Default Resource for configuring SSRS with IIS

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
Reply With Quote
  #2  
Old 08-27-2008, 11:37 AM
Default Re: Resource for configuring SSRS with IIS

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.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Matt" wrote in message
news:A5877178-E19F-4418-90ED-256B9FF47EC9-at-microsoft.com...
> 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



Reply With Quote
  #3  
Old 08-28-2008, 05:01 AM
Default Re: Resource for configuring SSRS with IIS

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

"Bruce L-C [MVP]" wrote:

> 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.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Matt" wrote in message
> news:A5877178-E19F-4418-90ED-256B9FF47EC9-at-microsoft.com...
> > 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

>
>
>

Reply With Quote
  #4  
Old 08-28-2008, 09:57 AM
Default Re: Resource for configuring SSRS with IIS

That is best. Let RS handle everything and it will go totally smoothly.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Matt" wrote in message
news:0A1EED0C-F3F0-4CE1-95F5-FCF99F27894D-at-microsoft.com...
> 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
>
> "Bruce L-C [MVP]" wrote:
>
>> 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.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Matt" wrote in message
>> news:A5877178-E19F-4418-90ED-256B9FF47EC9-at-microsoft.com...
>> > 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

>>
>>
>>



Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:42 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.