Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

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?

Tuesday, March 20, 2012

reporting services logfiles?

can anyone tell me why the reporting service is dumping its logs in this
folder?
C:\Documents and Settings\NetworkService\Local Settings\Temp\LogFiles
Is there a way to prevent this or get the logs back into: C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFilesCheck out this article:
http://groups.google.de/groups?q=logfiles+reporting+services+location&hl=de&lr=&selm=%23BKJcPPSEHA.568%40TK2MSFTNGP12.phx.gbl&rnum=2
"ECS" <ecs@.netset.com> schrieb im Newsbeitrag
news:uLHOWn8PFHA.904@.tk2msftngp13.phx.gbl...
> can anyone tell me why the reporting service is dumping its logs in this
> folder?
> C:\Documents and Settings\NetworkService\Local Settings\Temp\LogFiles
> Is there a way to prevent this or get the logs back into: C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
>|||ok thanks - is there a way to get sql reporting services to clean up its own
logfiles?|||Sure, look in the settings
"
KeepFilesForDays or
FileSizeLimitMb
ReportingServicesService Configuration File
ReportingServicesService.exe.config includes settings that configure
tracing.
File Location
This file is located in the \Reporting Services\Report Server\Bin folder."
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configfiles_v1_1pia.asp
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
<ecs@.netset.com> schrieb im Newsbeitrag
news:urcjumcQFHA.1528@.TK2MSFTNGP09.phx.gbl...
> ok thanks - is there a way to get sql reporting services to clean up its
> own logfiles?
>