Hi, i am facing the problem with the reporting server which was working fine till recently. Once our server was down and this stopped working and returning me an error THE REQUEST FAILED WITH HTTP STATUS 401: UNAUTHORIZED. When i tried to go to IIS and check by r-clicking browse, it shows me the same error. Can anyone please help me on this. i need it very urgent. Thank you, Ramakrishna

Can you give the following details: Is it failing locally as well as remotely? Which version of reporting services you are using, can I have the build number? (You can get the build number by trying to browse the ReportServer URL) Did we change any service accounts? I mean, did you happen to change the service account of SQL Server or the Reporting Services? What is the operating system where you have SSRS running? Try the following: http://support.microsoft.com/kb/896861 [method 2] Hope this helps.. Chaitanya (http://twitter.com/chmediko)

Hi, It is failing both locally and remotely also. I am currently using MSSQL.4 My report server is installed on Windows server 2003 and remotely running on xp sp2. I tried with the link provided by you, but it's not working. I am getting Failure Audit, event id 529, Logon Failure: Reason: Unknown user name or bad password User Name: user Domain: xxxx-xxxxxxx Logon Type: 8 Logon Process: Advapi Authentication Package: Negotiate Workstation Name: xxxx-xxxxxxx Does this to do anything with the passwords, please let me know. Thank you Ramakrishna

Looks like you are hitting a Kerberos issue. What is the windows service account for your Reporting Serivces? Can you check the same from your configuration manager?Chaitanya (http://twitter.com/chmediko)

I am sorry, could you please tell me how/where to check this.

Goto Start> All Programs> Microsoft SQL Server 2005> Configuration Tools. Open the Reporting Services Configuration manager, and you will see an option called Windows Service Identity. What account is being used here? Is it any windows account? You can check the pictorial representation of the Config manager here: http://www.databasejournal.com/features/mssql/article.php/3683406/Black-Belt-Administration--Reporting-Services-Configuration-Manager.htm Chaitanya (http://twitter.com/chmediko)

Hi, i am using NT Authority\NetworkService. Regards, Ramakrishna

Hi... Its LocalSystem Thank you Ramakrishna

Can you check what is there in your SSRS log files. The path of Log files is: located at <Installation Directory>\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles After you reproduce the issue, check for the latest ReportServer_<timestamp>.log Chaitanya (http://twitter.com/chmediko)

Hi.... I could not find the log for that particular time when the error has occurred. But i am putting the latest log. <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product> <Locale>en-US</Locale> <TimeZone>India Standard Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerWebApp__01_06_2011_18_29_03.log</Path> <SystemName>xxxxx-xxxxxxxxxx</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName> <OSVersion>5.2.3790.131072</OSVersion> </Header> w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!1!1/6/2011-18:29:04:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. w3wp!ui!1!1/6/2011-18:29:07:: e ERROR: The request failed with HTTP status 401: Unauthorized. w3wp!ui!1!1/6/2011-18:29:07:: 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!1/6/2011-18:29:08:: 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) Thank you Ramakrishna.

This looks like a Kerberos issue to me. There is a possibility that the service account backend SQL Server where your catalog databases are stored, might have got changed. Please follow: http://support.microsoft.com/kb/319723 You might need to engage your SQL Server Admins here to verify the SPNs, and set them if they are missing. Hope this helpsChaitanya (http://twitter.com/chmediko)