Cannot restore Report Server to a new machine

Original machine is Windows 2000 with SQL Server 2000 Enterprise SP3 and RS
SP1 all english, new machine is Win2003 with SQL Server 2000 Enterprise SP3
and RS SP1, all german.
The new machine doesn't have the same network name as the original machine.
After a first failed attempt, I decided to start over again on the new
machine:
I de-installed Reporting Services, and reinstalled, applied SP1.
The RS server was functionnal.
I applied the Forms Authentication changes as per the Microsoft article.
The RS server was functionnal.
I restored the ReportServer and ReportServerTempDB from the Win2000 server
and copied the encryption key using rskeymgmt. I made sure that the accounts
on the restored DBs are ok by running sp_change_users_login
I'm still getting the same error:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)
I run rsactivate, and I'm still getting the error.
All possible users have been given SA priviledges on the SQL Server (ASPNET,
IUSR_xxx, the account used by RS to connect to SQL, the local admin and the
administrators group)
Could it be because:
1) You cannot restore a RS server from a Win2000 English machine to a
Win2003 German machine?
2) You cannot restore a RS Server to a server that has a different name?
PS: This is a continuation of post about RSActivate since I have now been
able to narrow down the problem to the reporting server restore, instead of
rsactivate.
Here are the logs, from ReportServer and ReportServerWebApp:
<Header>
<Product>Microsoft SQL Server Reporting Services, Version
8.00.878.00</Product>
<Locale>de-DE</Locale>
<TimeZone>Mitteleuropäische Sommerzeit </TimeZone>
<Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path>
<SystemName>xxxxxxTEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: Unable to communicate with report
server. Please verify that the report server is operational.
w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: HTTP status code --> 500
<Header>
<Product>Microsoft SQL Server Reporting Services, Version
8.00.878.00</Product>
<Locale>de-DE</Locale>
<TimeZone>Mitteleuropäische Sommerzeit </TimeZone>
<Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__05_10_2005_10_05_47.log</Path>
<SystemName>xxxxxTEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!a44!10.05.2005-10:05:47:: i INFO: Reporting Web Server started
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!a44!10.05.2005-10:05:47:: i INFO: Running on 0
physical processors, 1 logical processors
w3wp!resourceutilities!a44!10.05.2005-10:05:47:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!af8!05/10/2005-10:06:07:: i INFO: Call to GetPermissions:/
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!af8!05/10/2005-10:06:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.
w3wp!library!af8!05/10/2005-10:06:11:: i INFO: Call to GetSystemPermissions
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:12:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!af8!05/10/2005-10:06:12:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you are not able to move Reporting
Services from Windows 2000 to Windows Server 2003. If I have misunderstood
your concern, please feel free to point it out.
Based on my knowlege, we have a Knowledge Base article describes how to
move a Reporting Services database from a computer that is running
Microsoft SQL Server Reporting Services to another computer. You could
follow the step by step in the MORE INFORMATION section
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/kb/842425
From the log file you have posted, I have noticed following entries
=============w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
Not attempting activation.
=============
Though the user can login to SQL machine, this error happens if the logged
user account which is used to run the Rsactivate did not have permission on
the database and database objects in SQL Server, specifically the
reportserver and reportservertempdb.
You should add the user account which is used to run the rsactivate to the
sql server box as a local admin. By default local admin has full privileges
on the database and the database objects. If you cannot add them as local
admin, you can add them just to the reportserver and reportservertempdb.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
As far as I can tell, I did follow the procedure, and also I did run the
rsactivate as a local admin.
In the meantime, I have opened a support case with Microsoft in Germany.
Many thanks.
"Michael Cheng [MSFT]" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you are not able to move Reporting
> Services from Windows 2000 to Windows Server 2003. If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowlege, we have a Knowledge Base article describes how to
> move a Reporting Services database from a computer that is running
> Microsoft SQL Server Reporting Services to another computer. You could
> follow the step by step in the MORE INFORMATION section
> How to move a Reporting Services database from a computer that is running
> Reporting Services to another computer
> http://support.microsoft.com/kb/842425
> From the log file you have posted, I have noticed following entries
> =============> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
> NT-AUTORITÃ?â'T\NETZWERKDIENST
> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
> w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
> Not attempting activation.
> =============> Though the user can login to SQL machine, this error happens if the logged
> user account which is used to run the Rsactivate did not have permission on
> the database and database objects in SQL Server, specifically the
> reportserver and reportservertempdb.
> You should add the user account which is used to run the rsactivate to the
> sql server box as a local admin. By default local admin has full privileges
> on the database and the database objects. If you cannot add them as local
> admin, you can add them just to the reportserver and reportservertempdb.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
Thanks for your understanding, you are welcome to let us know the result
when your case was finally resolved. Share it in the newsgroup and I
believe others will definitely benefit from your contribution.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Got a solution after 2 weeks of hard work from PSS.
See resolution under thread "RS Activation is failing"
"Michael Cheng [MSFT]" wrote:
> Hi,
> Thanks for your understanding, you are welcome to let us know the result
> when your case was finally resolved. Share it in the newsgroup and I
> believe others will definitely benefit from your contribution.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi James,
GREAT!
Thanks for your sharing it with us! For others convenience, I post the
RESOLUTION here
--
Newsgroups: microsoft.public.sqlserver.reportingsvcs
From: "James" <aa1...@.nospam.nospam> - Find messages by this author
Date: Fri, 27 May 2005 08:32:10 -0700
Local: Fri,May 27 2005 11:32 am
Subject: RE: RS Activation is failing
I got the solution. One needs to first transfer the 2 databases and restore
them on the new server, copy the encryption key and run rskeymgmt.
Then go to the Report manager so that the RS installation gets activated.
And then and only then, reapply all changes necessary to implement forms
auth.
My problem was that I had copied the 6 config files that are involved in
forms auth from the old server, and there is encrypted info in there that
isn't valid on the new server. Also, activation only works in Windows
authentication mode, that's why one has to start in Windows mode, and only
then move to Forms Auth.
--
Thanks James!! Once more for your efforts!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.