Link to home
Start Free TrialLog in
Avatar of mce-man-it
mce-man-it

asked on

SQL 2005 Migration error

We're migrating our SQL 2005 box from an old Windows 2003 32-bit server to a new 2008 64-bit box and having a few issues.

We're trying to keep the server name the same (MANAPP03) but when we down the old box and bring the new one up to test, we're getting the following error in the reporting services:

Unable to initialise report server service after migration to new Windows server. Service starts but does not initialise.

I've attached a screenshot and below is the reporting services log - any help will be much appreciated as we're aiming to go live with the new box this weekend.

Reporting services log file after starting service


<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>GMT Standard Time</TimeZone>
  <Path>C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__03_08_2010_17_34_59.log</Path>
  <SystemName>MANAPP03</SystemName>
  <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>
  <OSVersion>6.0.6002.131072</OSVersion>
</Header>
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing ReportBuilderTrustLevel to '0'  as specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: 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!3!08/03/2010-17:35:00:: 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!3!08/03/2010-17:35:00:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!3!08/03/2010-17:35:00:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!3!08/03/2010-17:36:17:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!3!08/03/2010-17:36:18:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
   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!3!08/03/2010-17:36:20:: 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!8!08/03/2010-17:46:17:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!8!08/03/2010-17:46:17:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
   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)


then I've attached the error that happens when we try and save the changes
sql-2005.JPG
error2.JPG
Avatar of Dustin_Loftis
Dustin_Loftis
Flag of United States of America image

Was the old server running SQL 2000 or 2005?
Avatar of mce-man-it
mce-man-it

ASKER

Yep, the old box was on SQL 2005 as well.
I see, so the new box is also running 2005.  I misunderstood that.  

So to perform this migration, you installed 2005 on the new server, backed up and restored the database to it?  Or did you use another method?
Yeah, both are running SQL 2005, the only difference is much newer hardware and Windows 2008 64-bit.

The process was install Windows 2008, Install SQL 2005, restore the database then go through the configuration tool which is where we get the errors initialising the service.
Okay.  And all of the same program pieces, such as the report server, are running on the new server?
Yeah, everything should be installed as it was on the old box
ASKER CERTIFIED SOLUTION
Avatar of mce-man-it
mce-man-it

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial