February 4, 2009 at 11:56 am
Hello,
I posted this in the Admin forum, but I believe this may be a better place for it.
I have SSRS installed on one of my database servers. For some reason I am unable to connect to it via http://servername/reports. I get the familiar blue and yellow line of the Report Manager header, but I receive the "HTTP status 401: Unauthorized" message. Additionally, if I try to connect to the Reporting Services instance from the server with Windows Authentication using Management Studio, I get a similar message. But if I do it with Basic authentication, using the same domain logon account and password in SSMS, it works. Oddly enough, I can connect to the Reporting Services instance from a client pc using SSMS and Windows security.
I can connect to the report server via http://servername/reportserver, and I can actually run the reports. It's just the report manager that's giving me fits.
Both the Reports and ReportServer virtual directories are set up for Windows authentication only, and they run in their own application pool on the 2003 server.
I have SSRS installations on other servers, and they work correctly. I have compared settings until my eyes ran together, and I've found nothing to indicate the problem.
Any ideas?
February 4, 2009 at 12:12 pm
The link below shows IIS 6 default folder permissions and you can go to the location below in your C drive to run aspnet_regiis utility. This will take care of permissions but IIS 6 comes locked down to render only static html so if you can remove your existing install and add it again this time click on details you will see all the features needed to run Asp.net enable most if not all. And in other user boxes all that is needed is excluding the Report Server IP address. This will get you started.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
http://support.microsoft.com/kb/812614
Kind regards,
Gift Peddie
February 4, 2009 at 1:04 pm
Thanks for your reply.
Are you saying that I need to remove my existing SSRS installation? This is on a production box. Is there a way to remove SSRS without removing the whole SQL Server installation?
Also, is it OK to run aspnet_regiis when I have a mixture of 1.1 and 2.0 apps running in different application pools?
February 4, 2009 at 2:01 pm
No I am talking about removing IIS 6 and adding it again and click on details and you will see all the features needed to run Asp.net. And yes it is OK to run aspnet_regsiis.
When you have both 1.1 and 2.0 running you just need Application element in your 1.1 web.config, finding the links too longer than expected. This will take care of the two .NET framework in one IIS 6, the only restriction you cannot run both 32bit(x86) and 64bits(x64) in one IIS 6. Post again if you still need help.
http://msdn.microsoft.com/en-us/library/w4atty68.aspx
http://msdn.microsoft.com/en-us/library/d5cd9b2c.aspx
Kind regards,
Gift Peddie
February 4, 2009 at 2:20 pm
Thanks for the post.
I already have other ASP.Net 1.1 and 2.0 web applications running correctly on this server. I verified that a moment ago by going to one of them. ASP.Net seems to be working fine inside IIS. Do you still think I need to uninstall/reinstall IIS 6?
February 4, 2009 at 2:24 pm
No just see if you can run aspnet_regiis and apply some of the relevant folder permissions for the SSRS virtual directory and deployment folders.
Kind regards,
Gift Peddie
February 4, 2009 at 2:43 pm
What command line arguments should I pass when I run aspnet_regiis?
February 4, 2009 at 2:47 pm
Here are the switches go through it and choose the one suited for your SSRS and Asp.net applications to run in one IIS 6.
http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
Kind regards,
Gift Peddie
February 4, 2009 at 3:22 pm
I did the -s option and specified the path to the reports virtual directory. Then I ran it again with -s and specified the reportserver virtual directory. It ran for a few secondes each time, but I haven't noticed anything different. I still get the same error message. I bounced IIS to see if that made a difference, but it didn't. I haven't rebooted the server.
February 4, 2009 at 3:31 pm
I looked at it and thinks the enable switch is more suited for your situation. But the other option of applying the default folder permissions like the ones in the registry for the many directories. And reboot the box each time.
Kind regards,
Gift Peddie
February 5, 2009 at 6:53 am
Here's some additional info. It's the logfile that's generated when I get the error:
w3wp!ui!1!2/5/2009-07:47:49:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!1!2/5/2009-07:47:49:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!2/5/2009-07:47:50:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
February 5, 2009 at 7:21 am
Here's the log that's created when I get the error message:
w3wp!ui!1!2/5/2009-07:47:49:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!1!2/5/2009-07:47:49:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!2/5/2009-07:47:50:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
February 5, 2009 at 7:31 am
I was in another thread I was right it relates to you running all those applications in one IIS 6 which makes SSRS using none default web site so here is the configuration from Microsoft. And another thread with the issue make sure you read and check all the referenced support articles in the Microsoft page because that covers what will stop these errors.
http://technet.microsoft.com/hi-in/library/ms155921(en-us).aspx
http://www.sqlreportingservices.net/Ask/1796.aspx
Kind regards,
Gift Peddie
February 5, 2009 at 9:56 am
Thanks for the response.
My Reports and ReportServer virtual directories are on the Default Web Site, along with several other virtual directories. The Reports and ReportServer virtuals are using their own Applicaton Pool. The application pool is using the Network Service account for identity. If I change it to use a domain account, I get the "3 login box" behavior described in one of the links. If I change the app pool's identity to Local Service, I get an error message about creating a temporary class. If I set it to Local System, it behaves the same way as it does for Network Service, which was the original setting.
I've tried the NTLM fix, but it broke both the Reports and ReportServer sites. I changed that back.
February 5, 2009 at 10:22 am
I would say it is time to remove IIS 6 and put it back with the correct configurations but this is not a simple decision so here are the default folder permissions for Asp.net which is used by SQL Server 2005 SSRS.
The link below are about seven folders you need to give network service permissions and see if you can add network service to the IUSER group in Windows AD configurations. Try the above and I think I have a thread that may resolve your problem I have to look for it.
http://msdn.microsoft.com/en-us/library/kwzs111e.aspx
Here is the thread removing IIS 6 and adding it again was the solution.
http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/0b31c796-acdd-449c-b06a-9dbc409b90b0/
Kind regards,
Gift Peddie
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply