Monday, March 26, 2012

Reporting Services Reinstallation Problem

Somehow i messed up some IIS settings for Reporting Services and had to uninstall and reinstall Reporting Services. When reinstalling it, i get warnings about existing Report Server and tempReportServer database so i removed those 2 databases from SQL Server 2000. At the end of the installation, another warning popped up saying I need to initialize the report server manually. I ran rsconfig and rsactivate to initialize the report server. Now i get a no page found error when load http://localhost/reports. I can't seem to get any good documentation on the web for reporting services since it's fairly new. Please help.i can understand. its been a pain with the RS and no proper documentation so far. i've had to uninstall and reinstall the RS almost a dozen times one day in trying to get the forms authentication working. i dont know what problem you have but when u uninstall,
(1) delete the 2 databases from the sql server - reportserver and reportservertempdb
(2) are u using ssl ? if not you need to change the security level to 0. its 3 by default.
by default its in : C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder. in the RSReportServer file. theres a tag
<Add Key="SecureConnectionLevel" Value="3"/>. change the 3 to 0.

hth|||Thank for the reply. I did follow these 2 steps when reinstalling reporting services, but i still get the "setup could not initialize report server" message at the end of the installation process. Here's the log file hope someone can tell me what's wrong:

w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!ui!87c!7/27/2004-10:45:38:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!87c!7/27/2004-10:45:39:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

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.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!87c!7/27/2004-10:45:51:: 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)
w3wp!ui!87c!7/27/2004-10:46:54:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!87c!7/27/2004-10:46:54:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

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.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!87c!7/27/2004-10:46:54:: 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)|||i cant make out where the problem is. check this site :http://hdconsultants.us/archive/2004/04/07/560.aspx

you can try these too :
1/ Start the Report Server Windows service if it is not already running. For more information, see "Starting and Stopping the Report Server Service" in Books Online.

2/ Click Start, click Run, type cmd in the text box, and then click OK.

3/ At the command prompt, type rsactivate -r. For more information, see "rsactivate Utility" in SQL Server 2005 Books Online.

4/ Restart IIS.

hth|||Still not working. After several times uninstalling and reinstalling it again, i'm now able to access the ReportServer folder, but everytime i try to access localhost/Reports (report manager) it gives me an error saying "The request failed with HTTP status 401: Unauthorized." I am still getting the "setup cannot initialize report server instance" warning after each installation. I am suspecting an IIS problem. Anyone else wanna try this one?

No comments:

Post a Comment