| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 |
|
#2
|
| 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" 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 |
|
#3
|
| 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" > 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 > > > |
|
#4
|
| That is best. Let RS handle everything and it will go totally smoothly. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Matt" 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" >> 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 >> >> >> |
![]() |
| Thread Tools | |
| Display Modes | |