SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Services SQL 2000 Installation


Report Services SQL 2000 Installation

Author
Message
shani19831
shani19831
SSC Journeyman
SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)

Group: General Forum Members
Points: 86 Visits: 228
Hi Guys,

I have had a hectic month trying to resolve this.

We have reporting services 2000 on two different servers, namely Production and Test, this are all operational and the for Test server it was done by someone else who no longer workers with us.

The DR server did not have reporting services installed. i therefore installed it and created new reporting databases. Later when it was all installed i asked the DBA to copy over the ReportServer and ReportServerTempDB from the production server onto the DR in order to make use on the database and i dont have to create the millions of reports from scratch. That was done and i point reporting services to make use of the databases copied over, when i open the url i could see all the reports but i cant execute them nor vied the data sources.

Please save me time in getting this reports to show on the DR site server?
Below is a log file that i obtained but i cant understand whats going on.

The last thing i did was, detach all the ReportServer db, then reattach but still no hope.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__09_03_2013_10_30_00.log</Path>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!ui!428!9/3/2013-10:30:00:: e ERROR: System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.f()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.as()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.am()
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
at Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
at Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
w3wp!ui!428!9/3/2013-10:30:00:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.f()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.as()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.am()
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
at Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
at Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)

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.GetProperties(String Item, Property[] Properties)

at Microsoft.SqlServer.ReportingServices.RSConnection.GetProperties(String Item, Property[] Properties)

at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)

at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)

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!428!9/3/2013-10:30:00:: 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!b44!9/3/2013-10:30:53:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectString(Byte[] protectedData)
at Microsoft.ReportingServices.DataExtensions.DataSourceInfo.GetConnectionString()
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi, Boolean getPassword)
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi)
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
w3wp!ui!b44!9/3/2013-10:30:53:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectString(Byte[] protectedData)
at Microsoft.ReportingServices.DataExtensions.DataSourceInfo.GetConnectionString()
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi, Boolean getPassword)
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi)
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)

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.GetDataSourceContents(String DataSource)

at Microsoft.SqlServer.ReportingServices.RSConnection.GetDataSourceContents(String DataSource)

at Microsoft.ReportingServices.UI.DataSourceProperties.LoadSharedDataSourceFromServer()

at Microsoft.ReportingServices.UI.DataSourceProperties.Control_Load(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!b44!9/3/2013-10:30:53:: 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)
happycat59
happycat59
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4727 Visits: 3215
You cannot simply restore a reporting services database from another SSRS installation over the top of the SSRS database of another installation. This is because SSRS encrypts parts of the content of the database and the database restore process does not know about this.

The steps for doing this can be found in this article : http://support.microsoft.com/kb/842425



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search