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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-12 : 08:07:43
|
| Janet writes "Don't get mad - I did post on 11/4 (and also on four other forums), but nobody has been able to help. Have received five emails stating similar problem and would appreciate a heads up if someone helps me.Posted - 11/04/2004 : 14:48:26 ----------------------------------------------------------------Have split-brain dns (server2003 with AD) natted at the firewall with 5 domains - one internal only and dynamic; all others static for basically websites and email pointers. Websites, email, sql, asp pages are working fine - EXCEPT REPORTING SERVICES!!!I have uninstalled, reinstalled, added IUSR_MachineName to users and role assignment as browse in RS. Gave IUSR_MachineName read permissions to folder and have the following to report:With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> not added.Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to no anonymous and winAuth on: Security options and reports display appropriately. Not viewable using interal ip address. Viewable from outside the firewall using external ip address only after login prompt.With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> added.Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to anonymous and winAuth on: Using Internal IP: Login, then Folder Listing, Security options do not display and reports give page not found. Report server - report viewableUsing ServerName: Login, Folder Listing, Security options do not display and reports give page not found. Report server - report viewable.Using External IP outside Firewall: Login, Folder Listing, Security options do not display and reports give page not found under Reports. Report server - report viewable.Using domain name: Reports - page not found, ReportServer - page not found.With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> added.Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to anonymous and winAuth on AND virtual directories added under website AND home.aspx added and moved to top under documents for virtual directory: Using Internal IP: Folder Listing (no login), Security options do not display and reports give 403.8. Report server - report viewableUsing ServerName: Folder Listing (no login), Security options do not display and reports give 403.8. Report server - report viewable.Using External IP outside Firewall: Login, Folder Listing, Security options do not display and reports give page 403.8. Report server - report viewable.Using domain name url: Reports - 403.8; ReportServer - 403.8Since web is on same server as sql, also changed config tag to:<UI><ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory></UI> " |
|
|
|
|
|
|
|
Reporting Services