403 Error

I've been tasked with moving several reports from a pre-production
environment to production. Sounded easy enough for me; except they left out
that the production environment has some SSRS issues. I've been working
through these and have resolved most of them. The remaining one is very
perplexing, and I can't seem to pinpoint the root cause of the error message.
The management console works just fine, and I'm also able to deploy existing
reports to the new server, however, SSRS is not able to render any reports.
I constantly receive a 403 Forbidden error. Both systems are using Windows
Server 2003 and SQL Server 2005, although they are different service pack
versions. I have duplicated all security permissions from the pre-production
box to the production one, to no avail. The Event Viewer has finally logged
an error message, but it's all Greek to me. The error is listed below.
If anyone could provide some insight, I would be very gratefull.
TIA,
Chris
Error Message:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/10/2007 4:45:29 PM
Event time (UTC): 7/10/2007 11:45:29 PM
Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
Event sequence: 191
Event occurrence: 4
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: *****
Process information:
Process ID: 4020
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL:
http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address:
User:
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
isAbortable, String url, Stream outputStream, String& mimeType, String&
fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
styleSheetName)
at
Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context)
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.On Jul 10, 8:14 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> I've been tasked with moving several reports from a pre-production
> environment to production. Sounded easy enough for me; except they left out
> that the production environment has some SSRS issues. I've been working
> through these and have resolved most of them. The remaining one is very
> perplexing, and I can't seem to pinpoint the root cause of the error message.
> The management console works just fine, and I'm also able to deploy existing
> reports to the new server, however, SSRS is not able to render any reports.
> I constantly receive a 403 Forbidden error. Both systems are using Windows
> Server 2003 and SQL Server 2005, although they are different service pack
> versions. I have duplicated all security permissions from the pre-production
> box to the production one, to no avail. The Event Viewer has finally logged
> an error message, but it's all Greek to me. The error is listed below.
> If anyone could provide some insight, I would be very gratefull.
> TIA,
> Chris
> Error Message:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 7/10/2007 4:45:29 PM
> Event time (UTC): 7/10/2007 11:45:29 PM
> Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> Event sequence: 191
> Event occurrence: 4
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> Trust level: RosettaMgr
> Application Virtual Path: /Reports
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportManager\
> Machine name: *****
> Process information:
> Process ID: 4020
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: WebException
> Exception message: The remote server returned an error: (403) Forbidden.
> Request information:
> Request URL:
> http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> Request path: /Reports/Reserved.ReportViewerWebControl.axd
> User host address:
> User:
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> isAbortable, String url, Stream outputStream, String& mimeType, String&
> fileNameExtension)
> at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> styleSheetName)
> at
> Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context)
> at
> System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> Custom event details:
> For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
You may want to recreate the website under a different name/virtual
directory. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Jul 10, 8:14 pm, Christopher Robin
> <ChristopherRo...@.discussions.microsoft.com> wrote:
> > I've been tasked with moving several reports from a pre-production
> > environment to production. Sounded easy enough for me; except they left out
> > that the production environment has some SSRS issues. I've been working
> > through these and have resolved most of them. The remaining one is very
> > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > The management console works just fine, and I'm also able to deploy existing
> > reports to the new server, however, SSRS is not able to render any reports.
> > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > Server 2003 and SQL Server 2005, although they are different service pack
> > versions. I have duplicated all security permissions from the pre-production
> > box to the production one, to no avail. The Event Viewer has finally logged
> > an error message, but it's all Greek to me. The error is listed below.
> >
> > If anyone could provide some insight, I would be very gratefull.
> >
> > TIA,
> > Chris
> >
> > Error Message:
> >
> > Event code: 3005
> > Event message: An unhandled exception has occurred.
> > Event time: 7/10/2007 4:45:29 PM
> > Event time (UTC): 7/10/2007 11:45:29 PM
> > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > Event sequence: 191
> > Event occurrence: 4
> > Event detail code: 0
> >
> > Application information:
> > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > Trust level: RosettaMgr
> > Application Virtual Path: /Reports
> > Application Path: C:\Program Files\Microsoft SQL
> > Server\MSSQL.3\Reporting Services\ReportManager\
> > Machine name: *****
> >
> > Process information:
> > Process ID: 4020
> > Process name: w3wp.exe
> > Account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Exception information:
> > Exception type: WebException
> > Exception message: The remote server returned an error: (403) Forbidden.
> >
> > Request information:
> > Request URL:
> > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > User host address:
> > User:
> > Is authenticated: True
> > Authentication Type: Negotiate
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> >
> > Thread information:
> > Thread ID: 1
> > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > Is impersonating: True
> > Stack trace: at
> > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > fileNameExtension)
> > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > styleSheetName)
> > at
> > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > context)
> > at
> > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously)
> >
> > Custom event details:
> >
> > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
>
> You may want to recreate the website under a different name/virtual
> directory. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Hi Enrique,
I don't fully understand, what happened, but your suggestion worked
beautifully. Reporting Services is now showing the report I deployed, and
I'm not the only one that can access it.
Thanks for the help.
Chris|||On Jul 11, 12:52 pm, Christopher Robin
<ChristopherRo...@.discussions.microsoft.com> wrote:
> "EMartinez" wrote:
> > On Jul 10, 8:14 pm, Christopher Robin
> > <ChristopherRo...@.discussions.microsoft.com> wrote:
> > > I've been tasked with moving several reports from a pre-production
> > > environment to production. Sounded easy enough for me; except they left out
> > > that the production environment has some SSRS issues. I've been working
> > > through these and have resolved most of them. The remaining one is very
> > > perplexing, and I can't seem to pinpoint the root cause of the error message.
> > > The management console works just fine, and I'm also able to deploy existing
> > > reports to the new server, however, SSRS is not able to render any reports.
> > > I constantly receive a 403 Forbidden error. Both systems are using Windows
> > > Server 2003 and SQL Server 2005, although they are different service pack
> > > versions. I have duplicated all security permissions from the pre-production
> > > box to the production one, to no avail. The Event Viewer has finally logged
> > > an error message, but it's all Greek to me. The error is listed below.
> > > If anyone could provide some insight, I would be very gratefull.
> > > TIA,
> > > Chris
> > > Error Message:
> > > Event code: 3005
> > > Event message: An unhandled exception has occurred.
> > > Event time: 7/10/2007 4:45:29 PM
> > > Event time (UTC): 7/10/2007 11:45:29 PM
> > > Event ID: 9a1bce04b5cb4a40bb2a25d886773a0e
> > > Event sequence: 191
> > > Event occurrence: 4
> > > Event detail code: 0
> > > Application information:
> > > Application domain: /LM/W3SVC/1/root/Reports-1-128285789610527498
> > > Trust level: RosettaMgr
> > > Application Virtual Path: /Reports
> > > Application Path: C:\Program Files\Microsoft SQL
> > > Server\MSSQL.3\Reporting Services\ReportManager\
> > > Machine name: *****
> > > Process information:
> > > Process ID: 4020
> > > Process name: w3wp.exe
> > > Account name: NT AUTHORITY\NETWORK SERVICE
> > > Exception information:
> > > Exception type: WebException
> > > Exception message: The remote server returned an error: (403) Forbidden.
> > > Request information:
> > > Request URL:
> > > http://***/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
> > > Request path: /Reports/Reserved.ReportViewerWebControl.axd
> > > User host address:
> > > User:
> > > Is authenticated: True
> > > Authentication Type: Negotiate
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Thread information:
> > > Thread ID: 1
> > > Thread account name: NT AUTHORITY\NETWORK SERVICE
> > > Is impersonating: True
> > > Stack trace: at
> > > Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> > > isAbortable, String url, Stream outputStream, String& mimeType, String&
> > > fileNameExtension)
> > > at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String
> > > styleSheetName)
> > > at
> > > Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> > > at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> > > context)
> > > at
> > > System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> > > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > > completedSynchronously)
> > > Custom event details:
> > > For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
> > You may want to recreate the website under a different name/virtual
> > directory. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Hi Enrique,
> I don't fully understand, what happened, but your suggestion worked
> beautifully. Reporting Services is now showing the report I deployed, and
> I'm not the only one that can access it.
> Thanks for the help.
> Chris
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant