After getting the "The report server installation is not initialized." error,
I have tried many suggestions from this newsgroup (registry key permissions,
erasing the encryption key from the RS config file, etc...
Nothing has helped, I'm still getting the error. The log file is as follows.
One error that looks significant to me is "Client is not a local admin. Not
attempting activation."
I'll be grateful for any help, and for any insight as to which "client" the
error message is referring to.
<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_03_2005_20_36_09.log</Path>
<SystemName>XXXTEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!b98!03.05.2005-20:36:09:: i INFO: Reporting Web Server started
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!b98!03.05.2005-20:36:09:: i INFO: Running on 0
physical processors, 1 logical processors
w3wp!resourceutilities!b98!03.05.2005-20:36:09:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Exporting public key
w3wp!crypto!474!03.05.2005-20:37:09:: w WARN: Web Service not activated
w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!474!03.05.2005-20:37:09:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation.
w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Exporting public key
w3wp!crypto!b98!03.05.2005-20:38:09:: w WARN: Web Service not activated
w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!b98!03.05.2005-20:38:09:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation.I forgot to mention:
SQL Server 2000 SP3, RS SP1, Win 2003, all in one box.|||Hello,
To understand the issue better, I'd like to know the following informaiton:
1. When you tried to run the following command, what is the result?
RSACTIVATE -C "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" (make sure the path is the
one you installed Reporting Services)
2. Did you log on as a local admin and try to access
http://localhost/reportserver link?
this error happens if the logged in 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.
I suggest that you 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.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVQFpoaVsyfZVL4RFuXyA0cnTIbaQ==| X-WBNR-Posting-Host: 145.254.231.5
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| Subject: RE: RS Activation is failing
| Date: Tue, 3 May 2005 12:30:45 -0700
| Lines: 2
| Message-ID: <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42650
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I forgot to mention:
| SQL Server 2000 SP3, RS SP1, Win 2003, all in one box.
||||1. I get a successful message when I run the suggested RSACTIVATE command
2. When I access http://localhost/reportserver, I get a page with a title of
"Reporting Services Error", and the text is "The report server installation
is not initialized. Check the documentation for more information.
(rsReportServerNotActivated) Get Online Help"
3. I am looged in as local admin, and the administrators group has SA
privileges on the SQL Server.
4. I have now added the NetworkService account to the local admin group, as
this is the account appearing in the log file (NetzwerkDienst stands for
NetworkService), I have stopped and restarted the ReportServer service, and
tried the RSACTIVATE again.
I'm still having the problem.
Also, this a fresh install on Win2003, using Forms Auth as per the Microsoft
article "Using Forms Authentication in Reporting Services.htm".
This setup is working on our current Win 2000 server English, and I'm trying
to upgrade the solution to Win 2003 German. Both RS installations are SP1.
I have been backing up the RS databases from the win2000 server and
restoring them on the win2003, I also copied the encryption key across using
rskeymgmt.|||Hello,
It seems to be issue caused by that form authentication was not configured
properly. Please try to use Windows authentication (default configuration)
to make sure it works properly. You could refer to the following
information from "Using Forms Authentication in Reporting Services" link.
Removing the Sample Extension
While not generally recommended, it is possible to revert back to Windows
Authentication after you have tried out the sample. To revert to Windows
security, do the following:
Restore the following files from your backup copies: Web.config,
RSReportServer.config, and RSWebApplication.config. This should set the
authentication and authorization methods for the report server to the
default Windows security. This should also remove any entries you made for
your extension in the Report Server or Report Manager configuration files.
Disable anonymous access in Internet Information Services (IIS) for the
report server virtual directory.
If it works at this time, you may try to configure form authenctication
again to troubleshoot the original issue.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==| X-WBNR-Posting-Host: 84.147.135.4
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Activation is failing
| Date: Wed, 4 May 2005 00:08:03 -0700
| Lines: 23
| Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42689
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 1. I get a successful message when I run the suggested RSACTIVATE command
| 2. When I access http://localhost/reportserver, I get a page with a title
of
| "Reporting Services Error", and the text is "The report server
installation
| is not initialized. Check the documentation for more information.
| (rsReportServerNotActivated) Get Online Help"
| 3. I am looged in as local admin, and the administrators group has SA
| privileges on the SQL Server.
| 4. I have now added the NetworkService account to the local admin group,
as
| this is the account appearing in the log file (NetzwerkDienst stands for
| NetworkService), I have stopped and restarted the ReportServer service,
and
| tried the RSACTIVATE again.
|
| I'm still having the problem.
|
| Also, this a fresh install on Win2003, using Forms Auth as per the
Microsoft
| article "Using Forms Authentication in Reporting Services.htm".
| This setup is working on our current Win 2000 server English, and I'm
trying
| to upgrade the solution to Win 2003 German. Both RS installations are SP1.
|
| I have been backing up the RS databases from the win2000 server and
| restoring them on the win2003, I also copied the encryption key across
using
| rskeymgmt.
|
||||I have restored the files as per your post, removed anonymous security for
the ReportServer and the Reports virtual directories, then restarted IIS and
the ReportServer service.
When I navigate to http://localhost/Reports/ I still experience the same
problem, and I now get a slightly different error message, with an error
number at the end of the message:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
-2147159550
"Peter Yang [MSFT]" wrote:
> Hello,
> It seems to be issue caused by that form authentication was not configured
> properly. Please try to use Windows authentication (default configuration)
> to make sure it works properly. You could refer to the following
> information from "Using Forms Authentication in Reporting Services" link.
> Removing the Sample Extension
> While not generally recommended, it is possible to revert back to Windows
> Authentication after you have tried out the sample. To revert to Windows
> security, do the following:
> Restore the following files from your backup copies: Web.config,
> RSReportServer.config, and RSWebApplication.config. This should set the
> authentication and authorization methods for the report server to the
> default Windows security. This should also remove any entries you made for
> your extension in the Report Server or Report Manager configuration files.
> Disable anonymous access in Internet Information Services (IIS) for the
> report server virtual directory.
> If it works at this time, you may try to configure form authenctication
> again to troubleshoot the original issue.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
>
> --
> | Thread-Topic: RS Activation is failing
> | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==> | X-WBNR-Posting-Host: 84.147.135.4
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: RS Activation is failing
> | Date: Wed, 4 May 2005 00:08:03 -0700
> | Lines: 23
> | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42689
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | 1. I get a successful message when I run the suggested RSACTIVATE command
> | 2. When I access http://localhost/reportserver, I get a page with a title
> of
> | "Reporting Services Error", and the text is "The report server
> installation
> | is not initialized. Check the documentation for more information.
> | (rsReportServerNotActivated) Get Online Help"
> | 3. I am looged in as local admin, and the administrators group has SA
> | privileges on the SQL Server.
> | 4. I have now added the NetworkService account to the local admin group,
> as
> | this is the account appearing in the log file (NetzwerkDienst stands for
> | NetworkService), I have stopped and restarted the ReportServer service,
> and
> | tried the RSACTIVATE again.
> |
> | I'm still having the problem.
> |
> | Also, this a fresh install on Win2003, using Forms Auth as per the
> Microsoft
> | article "Using Forms Authentication in Reporting Services.htm".
> | This setup is working on our current Win 2000 server English, and I'm
> trying
> | to upgrade the solution to Win 2003 German. Both RS installations are SP1.
> |
> | I have been backing up the RS databases from the win2000 server and
> | restoring them on the win2003, I also copied the encryption key across
> using
> | rskeymgmt.
> |
> |
>|||After looking for this error number on the Web, I found out that it relates
to the encryption keys. I restored a fresh backup from the win2000 server,
and copied the encryption keys across using rskeymgmt.
I can now get to the "Home" page of the RS Manager at URL
http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as soon as
I click on a folder, I get "An internal error occurred on the report server.
See the error log for more details. (rsInternalError) Get Online Help Object
reference not set to an instance of an object."
The corresponding log file contents are:
<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_05_2005_11_30_56.log</Path>
<SystemName>TEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetPermissions(String
itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
operCollection)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security.GetPermissions(String
itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
operCollection)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
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.GetPermissions(String
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
at Microsoft.ReportingServices.UI.FolderPage.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!cd4!5/5/2005-11:31:36:: 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)
"James" wrote:
> I have restored the files as per your post, removed anonymous security for
> the ReportServer and the Reports virtual directories, then restarted IIS and
> the ReportServer service.
> When I navigate to http://localhost/Reports/ I still experience the same
> problem, and I now get a slightly different error message, with an error
> number at the end of the message:
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> -2147159550
>
> "Peter Yang [MSFT]" wrote:
> > Hello,
> >
> > It seems to be issue caused by that form authentication was not configured
> > properly. Please try to use Windows authentication (default configuration)
> > to make sure it works properly. You could refer to the following
> > information from "Using Forms Authentication in Reporting Services" link.
> >
> > Removing the Sample Extension
> > While not generally recommended, it is possible to revert back to Windows
> > Authentication after you have tried out the sample. To revert to Windows
> > security, do the following:
> >
> > Restore the following files from your backup copies: Web.config,
> > RSReportServer.config, and RSWebApplication.config. This should set the
> > authentication and authorization methods for the report server to the
> > default Windows security. This should also remove any entries you made for
> > your extension in the Report Server or Report Manager configuration files.
> >
> > Disable anonymous access in Internet Information Services (IIS) for the
> > report server virtual directory.
> >
> > If it works at this time, you may try to configure form authenctication
> > again to troubleshoot the original issue.
> >
> > Regards,
> >
> > Peter Yang
> > MCSE2000/2003, MCSA, MCDBA
> > 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.
> >
> >
> >
> >
> > --
> > | Thread-Topic: RS Activation is failing
> > | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==> > | X-WBNR-Posting-Host: 84.147.135.4
> > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> > | Subject: RE: RS Activation is failing
> > | Date: Wed, 4 May 2005 00:08:03 -0700
> > | Lines: 23
> > | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> > | MIME-Version: 1.0
> > | Content-Type: text/plain;
> > | charset="Utf-8"
> > | Content-Transfer-Encoding: 7bit
> > | X-Newsreader: Microsoft CDO for Windows 2000
> > | Content-Class: urn:content-classes:message
> > | Importance: normal
> > | Priority: normal
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42689
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | 1. I get a successful message when I run the suggested RSACTIVATE command
> > | 2. When I access http://localhost/reportserver, I get a page with a title
> > of
> > | "Reporting Services Error", and the text is "The report server
> > installation
> > | is not initialized. Check the documentation for more information.
> > | (rsReportServerNotActivated) Get Online Help"
> > | 3. I am looged in as local admin, and the administrators group has SA
> > | privileges on the SQL Server.
> > | 4. I have now added the NetworkService account to the local admin group,
> > as
> > | this is the account appearing in the log file (NetzwerkDienst stands for
> > | NetworkService), I have stopped and restarted the ReportServer service,
> > and
> > | tried the RSACTIVATE again.
> > |
> > | I'm still having the problem.
> > |
> > | Also, this a fresh install on Win2003, using Forms Auth as per the
> > Microsoft
> > | article "Using Forms Authentication in Reporting Services.htm".
> > | This setup is working on our current Win 2000 server English, and I'm
> > trying
> > | to upgrade the solution to Win 2003 German. Both RS installations are SP1.
> > |
> > | I have been backing up the RS databases from the win2000 server and
> > | restoring them on the win2003, I also copied the encryption key across
> > using
> > | rskeymgmt.
> > |
> > |
> >
> >|||--=_NextPart_0001_4B0F9F18
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Hello,
It seems the issue is caused by some settings in web.config file.
I have included a web.config file on my test machine for your reference.
Please backup the original file on your server, replace with the file
attached, and then run iisreset to restart IIS services to test. It is
under %programfiles%\Microsoft SQL server\mssql\report services\reportServer
If the issue persists, please double check the rssvrpolicy.config file to
make sure it was not modified properly.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw==| X-WBNR-Posting-Host: 84.147.136.116
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
<YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
| Subject: RE: RS Activation is failing
| Date: Thu, 5 May 2005 03:03:09 -0700
| Lines: 274
| Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42831
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| After looking for this error number on the Web, I found out that it
relates
| to the encryption keys. I restored a fresh backup from the win2000
server,
| and copied the encryption keys across using rskeymgmt.
|
| I can now get to the "Home" page of the RS Manager at URL
| http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as
soon as
| I click on a folder, I get "An internal error occurred on the report
server.
| See the error log for more details. (rsInternalError) Get Online Help
Object
| reference not set to an instance of an object."
|
| The corresponding log file contents are:
|
| <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_05_2005_11_30_56.log</Path>
| <SystemName>TEST</SystemName>
| <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
| <OSVersion>5.2.3790.0</OSVersion>
| </Header>
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
MaxScheduleWait
| to default value of '1' second(s) because it was not specified in
| Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| DatabaseQueryTimeout to default value of '30' second(s) because it was
not
| specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName
to
| default value of 'MSSQLSERVER.1' because it was not specified in
| Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| ProcessRecycleOptions to default value of '0' because it was not
specified
| in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| RunningRequestsScavengerCycle to default value of '30' second(s) because
it
| was not specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| RunningRequestsDbCycle to default value of '30' second(s) because it was
not
| specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| RunningRequestsAge to default value of '30' second(s) because it was not
| specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| CleanupCycleMinutes to default value of '10' minute(s) because it was not
| specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| SecureConnectionLevel to default value of '1' because it was not
specified
| in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
DisplayErrorLink
| to 'True' as specified in Configuration file.
| w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| WebServiceUseFileShareStorage to default value of 'False' because it was
not
| specified in Configuration file.
| w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to
an
| instance of an object.
| at
|
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
| at
|
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
secDesc)
| at Microsoft.ReportingServices.Library.Security.GetPermissions(String
| itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| operCollection)
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| -- End of inner exception stack trace --
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| -- End of inner exception stack trace --
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to
an
| instance of an object.
| at
|
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
| at
|
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
secDesc)
| at Microsoft.ReportingServices.Library.Security.GetPermissions(String
| itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| operCollection)
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| -- End of inner exception stack trace --
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| -- End of inner exception stack trace --
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
|
| at
|
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall)
|
| at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| methodName, Object[] parameters)
|
| at
|
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
| Item)
|
| at
| Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
Item)
|
| at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
|
| at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
|
| at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
itemPath)
|
| at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
|
| at Microsoft.ReportingServices.UI.FolderPage.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!cd4!5/5/2005-11:31:36:: 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)
|
|
| "James" wrote:
|
| > I have restored the files as per your post, removed anonymous security
for
| > the ReportServer and the Reports virtual directories, then restarted
IIS and
| > the ReportServer service.
| > When I navigate to http://localhost/Reports/ I still experience the
same
| > problem, and I now get a slightly different error message, with an
error
| > number at the end of the message:
| > The report server installation is not initialized. Check the
documentation
| > for more information. (rsReportServerNotActivated) Get Online Help
| > -2147159550
| >
| >
| > "Peter Yang [MSFT]" wrote:
| >
| > > Hello,
| > >
| > > It seems to be issue caused by that form authentication was not
configured
| > > properly. Please try to use Windows authentication (default
configuration)
| > > to make sure it works properly. You could refer to the following
| > > information from "Using Forms Authentication in Reporting Services"
link.
| > >
| > > Removing the Sample Extension
| > > While not generally recommended, it is possible to revert back to
Windows
| > > Authentication after you have tried out the sample. To revert to
Windows
| > > security, do the following:
| > >
| > > Restore the following files from your backup copies: Web.config,
| > > RSReportServer.config, and RSWebApplication.config. This should set
the
| > > authentication and authorization methods for the report server to the
| > > default Windows security. This should also remove any entries you
made for
| > > your extension in the Report Server or Report Manager configuration
files.
| > >
| > > Disable anonymous access in Internet Information Services (IIS) for
the
| > > report server virtual directory.
| > >
| > > If it works at this time, you may try to configure form
authenctication
| > > again to troubleshoot the original issue.
| > >
| > > Regards,
| > >
| > > Peter Yang
| > > MCSE2000/2003, MCSA, MCDBA
| > > 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.
| > >
| > >
| > >
| > >
| > > --
| > > | Thread-Topic: RS Activation is failing
| > > | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==| > > | X-WBNR-Posting-Host: 84.147.135.4
| > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > > | Subject: RE: RS Activation is failing
| > > | Date: Wed, 4 May 2005 00:08:03 -0700
| > > | Lines: 23
| > > | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > > | MIME-Version: 1.0
| > > | Content-Type: text/plain;
| > > | charset="Utf-8"
| > > | Content-Transfer-Encoding: 7bit
| > > | X-Newsreader: Microsoft CDO for Windows 2000
| > > | Content-Class: urn:content-classes:message
| > > | Importance: normal
| > > | Priority: normal
| > > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:42689
| > > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > > |
| > > | 1. I get a successful message when I run the suggested RSACTIVATE
command
| > > | 2. When I access http://localhost/reportserver, I get a page with a
title
| > > of
| > > | "Reporting Services Error", and the text is "The report server
| > > installation
| > > | is not initialized. Check the documentation for more information.
| > > | (rsReportServerNotActivated) Get Online Help"
| > > | 3. I am looged in as local admin, and the administrators group has
SA
| > > | privileges on the SQL Server.
| > > | 4. I have now added the NetworkService account to the local admin
group,
| > > as
| > > | this is the account appearing in the log file (NetzwerkDienst
stands for
| > > | NetworkService), I have stopped and restarted the ReportServer
service,
| > > and
| > > | tried the RSACTIVATE again.
| > > |
| > > | I'm still having the problem.
| > > |
| > > | Also, this a fresh install on Win2003, using Forms Auth as per the
| > > Microsoft
| > > | article "Using Forms Authentication in Reporting Services.htm".
| > > | This setup is working on our current Win 2000 server English, and
I'm
| > > trying
| > > | to upgrade the solution to Win 2003 German. Both RS installations
are SP1.
| > > |
| > > | I have been backing up the RS databases from the win2000 server and
| > > | restoring them on the win2003, I also copied the encryption key
across
| > > using
| > > | rskeymgmt.
| > > |
| > > |
| > >
| > >
|
--=_NextPart_0001_4B0F9F18
Content-Type: application/octet-stream; name="web.config"
Content-Transfer-Encoding: base64
PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiID8+DQo8Y29uZmlndXJhdGlvbj4N
CiAgPGNvbmZpZ1NlY3Rpb25zPg0KICAgIDxzZWN0aW9uIG5hbWU9IlJTdHJhY2UiIHR5cGU9Ik1p
Y3Jvc29mdC5SZXBvcnRpbmdTZXJ2aWNlcy5EaWFnbm9zdGljcy5SU1RyYWNlU2VjdGlvbkhhbmRs
ZXIsTWljcm9zb2Z0LlJlcG9ydGluZ1NlcnZpY2VzLkRpYWdub3N0aWNzIiAvPg0KICA8L2NvbmZp
Z1NlY3Rpb25zPg0KICA8c3lzdGVtLmRpYWdub3N0aWNzPg0KICAgIDxzd2l0Y2hlcz4NCiAgICAg
IDwhLS0gMSA9IGVycm9yLCAyID0gd2FybmluZywgMyA9IGluZm8sIDQgPSB2ZXJib3NlIC0tPiAg
ICAgIA0KICAgICAgPGFkZCBuYW1lPSJEZWZhdWx0VHJhY2VTd2l0Y2giIHZhbHVlPSIzIiAvPg0K
ICAgIDwvc3dpdGNoZXM+DQogICAgPGFzc2VydCBhc3NlcnR1aWVuYWJsZWQ9ImZhbHNlIiAvPg0K
ICA8L3N5c3RlbS5kaWFnbm9zdGljcz4NCiAgPFJTdHJhY2U+DQogICAgPGFkZCBuYW1lPSJGaWxl
TmFtZSIgdmFsdWU9IlJlcG9ydFNlcnZlcl8iIC8+DQogICAgPGFkZCBuYW1lPSJGaWxlU2l6ZUxp
bWl0TWIiIHZhbHVlPSIzMiIgLz4NCiAgICA8YWRkIG5hbWU9IktlZXBGaWxlc0ZvckRheXMiIHZh
bHVlPSIxNCIgLz4NCiAgICA8YWRkIG5hbWU9IlByZWZpeCIgdmFsdWU9InRpZCwgdGltZSIgLz4N
CiAgICA8YWRkIG5hbWU9IlRyYWNlTGlzdGVuZXJzIiB2YWx1ZT0iZGVidWd3aW5kb3csIGZpbGUi
IC8+DQogICAgPGFkZCBuYW1lPSJUcmFjZUZpbGVNb2RlIiB2YWx1ZT0idW5pcXVlIiAvPg0KICAg
IDxhZGQgbmFtZT0iQ29tcG9uZW50cyIgdmFsdWU9ImFsbCxSdW5uaW5nSm9iczozIiAvPg0KICA8
L1JTdHJhY2U+DQogIDxzeXN0ZW0ud2ViPg0KICAgIDxhdXRoZW50aWNhdGlvbiBtb2RlPSJXaW5k
b3dzIiAvPg0KICAgIDxpZGVudGl0eSBpbXBlcnNvbmF0ZT0idHJ1ZSIgLz4NCiAgICA8Y29tcGls
YXRpb24gZGVmYXVsdExhbmd1YWdlPSJjIyIgZGVidWc9ImZhbHNlIj4NCiAgICAgIDxhc3NlbWJs
aWVzPg0KICAgICAgICA8Y2xlYXIgLz4NCiAgICAgICAgPGFkZCBhc3NlbWJseT0iUmVwb3J0aW5n
U2VydmljZXNXZWJTZXJ2ZXIiIC8+DQogICAgICA8L2Fzc2VtYmxpZXM+DQogICAgPC9jb21waWxh
dGlvbj4NCiAgICA8dHJhY2UgZW5hYmxlZD0iZmFsc2UiIHJlcXVlc3RMaW1pdD0iMTAiIHBhZ2VP
dXRwdXQ9ImZhbHNlIiB0cmFjZU1vZGU9IlNvcnRCeVRpbWUiIGxvY2FsT25seT0idHJ1ZSIgLz4N
CiAgICA8c2Vzc2lvblN0YXRlIG1vZGU9Ik9mZiIgLz4NCiAgICA8aHR0cEhhbmRsZXJzPg0KICAg
ICAgPGFkZCB2ZXJiPSIqIiBwYXRoPSJSZXNlcnZlZC5SZXBvcnRTZXJ2ZXIiIHR5cGU9Ik1pY3Jv
c29mdC5SZXBvcnRpbmdTZXJ2aWNlcy5XZWJTZXJ2ZXIuUmVwb3J0U2VydmljZUh0dHBIYW5kbGVy
LCBSZXBvcnRpbmdTZXJ2aWNlc1dlYlNlcnZlciIgLz4NCiAgICA8L2h0dHBIYW5kbGVycz4NCiAg
ICA8aHR0cE1vZHVsZXM+PC9odHRwTW9kdWxlcz4NCiAgICA8Z2xvYmFsaXphdGlvbiByZXF1ZXN0
RW5jb2Rpbmc9InV0Zi04IiByZXNwb25zZUVuY29kaW5nPSJ1dGYtOCIgLz4NCiAgICA8aHR0cFJ1
bnRpbWUgZXhlY3V0aW9uVGltZW91dCA9ICI5MDAwIiAvPg0KICAgICAgPHNlY3VyaXR5UG9saWN5
Pg0KICAgICAgICA8dHJ1c3RMZXZlbCBuYW1lPSJSb3NldHRhU3J2IiBwb2xpY3lGaWxlPSJyc3Ny
dnBvbGljeS5jb25maWciIC8+DQogICAgICA8L3NlY3VyaXR5UG9saWN5Pg0KICAgIDx0cnVzdCBs
ZXZlbD0iUm9zZXR0YVNydiIgb3JpZ2luVXJsPSIiIC8+DQogIDwvc3lzdGVtLndlYj4NCjwvY29u
ZmlndXJhdGlvbj4NCg==--=_NextPart_0001_4B0F9F18--|||I have restored the rssvrpolicy.config in both directories (ReportServer and
ReportManager) and I have the same problem. I didn't find the web.config file
from your server that you are mentionning (I don't know where to look for it).
I'm going to completely reinstall Reporting Services, and I'll also try to
get hotfix 821334 as it looks like it may be relevant.
thanks anyway.
"Peter Yang [MSFT]" wrote:
> Hello,
> It seems the issue is caused by some settings in web.config file.
> I have included a web.config file on my test machine for your reference.
> Please backup the original file on your server, replace with the file
> attached, and then run iisreset to restart IIS services to test. It is
> under %programfiles%\Microsoft SQL server\mssql\report services\reportServer
> If the issue persists, please double check the rssvrpolicy.config file to
> make sure it was not modified properly.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
>
> --
> | Thread-Topic: RS Activation is failing
> | thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw==> | X-WBNR-Posting-Host: 84.147.136.116
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
> | Subject: RE: RS Activation is failing
> | Date: Thu, 5 May 2005 03:03:09 -0700
> | Lines: 274
> | Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42831
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | After looking for this error number on the Web, I found out that it
> relates
> | to the encryption keys. I restored a fresh backup from the win2000
> server,
> | and copied the encryption keys across using rskeymgmt.
> |
> | I can now get to the "Home" page of the RS Manager at URL
> | http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as
> soon as
> | I click on a folder, I get "An internal error occurred on the report
> server.
> | See the error log for more details. (rsInternalError) Get Online Help
> Object
> | reference not set to an instance of an object."
> |
> | The corresponding log file contents are:
> |
> | <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_05_2005_11_30_56.log</Path>
> | <SystemName>TEST</SystemName>
> | <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> | <OSVersion>5.2.3790.0</OSVersion>
> | </Header>
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> MaxScheduleWait
> | to default value of '1' second(s) because it was not specified in
> | Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | DatabaseQueryTimeout to default value of '30' second(s) because it was
> not
> | specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName
> to
> | default value of 'MSSQLSERVER.1' because it was not specified in
> | Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | ProcessRecycleOptions to default value of '0' because it was not
> specified
> | in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | RunningRequestsScavengerCycle to default value of '30' second(s) because
> it
> | was not specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | RunningRequestsDbCycle to default value of '30' second(s) because it was
> not
> | specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | RunningRequestsAge to default value of '30' second(s) because it was not
> | specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | CleanupCycleMinutes to default value of '10' minute(s) because it was not
> | specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | SecureConnectionLevel to default value of '1' because it was not
> specified
> | in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> DisplayErrorLink
> | to 'True' as specified in Configuration file.
> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
> | WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> | specified in Configuration file.
> | w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to
> an
> | instance of an object.
> | at
> |
> Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
> licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
> | at
> |
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
> s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
> secDesc)
> | at Microsoft.ReportingServices.Library.Security.GetPermissions(String
> | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
> | operCollection)
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | -- End of inner exception stack trace --
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | -- End of inner exception stack trace --
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set to
> an
> | instance of an object.
> | at
> |
> Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
> licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
> | at
> |
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
> s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
> secDesc)
> | at Microsoft.ReportingServices.Library.Security.GetPermissions(String
> | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
> | operCollection)
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | -- End of inner exception stack trace --
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | -- End of inner exception stack trace --
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> |
> | at
> |
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> |
> | at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> | methodName, Object[] parameters)
> |
> | at
> |
> Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> | Item)
> |
> | at
> | Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
> Item)
> |
> | at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> |
> | at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
> |
> | at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
> itemPath)
> |
> | at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
> |
> | at Microsoft.ReportingServices.UI.FolderPage.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!cd4!5/5/2005-11:31:36:: 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)
> |
> |
> | "James" wrote:
> |
> | > I have restored the files as per your post, removed anonymous security
> for
> | > the ReportServer and the Reports virtual directories, then restarted
> IIS and
> | > the ReportServer service.
> | > When I navigate to http://localhost/Reports/ I still experience the
> same
> | > problem, and I now get a slightly different error message, with an
> error
> | > number at the end of the message:
> | > The report server installation is not initialized. Check the
> documentation
> | > for more information. (rsReportServerNotActivated) Get Online Help
> | > -2147159550
> | >
> | >
> | > "Peter Yang [MSFT]" wrote:
> | >
> | > > Hello,
> | > >
> | > > It seems to be issue caused by that form authentication was not
> configured
> | > > properly. Please try to use Windows authentication (default
> configuration)
> | > > to make sure it works properly. You could refer to the following
> | > > information from "Using Forms Authentication in Reporting Services"
> link.
> | > >
> | > > Removing the Sample Extension
> | > > While not generally recommended, it is possible to revert back to
> Windows
> | > > Authentication after you have tried out the sample. To revert to
> Windows
> | > > security, do the following:
> | > >
> | > > Restore the following files from your backup copies: Web.config,
> | > > RSReportServer.config, and RSWebApplication.config. This should set
> the
> | > > authentication and authorization methods for the report server to the
> | > > default Windows security. This should also remove any entries you
> made for
> | > > your extension in the Report Server or Report Manager configuration
> files.
> | > >
> | > > Disable anonymous access in Internet Information Services (IIS) for
> the
> | > > report server virtual directory.
> | > >
> | > > If it works at this time, you may try to configure form
> authenctication
> | > > again to troubleshoot the original issue.
> | > >
> | > > Regards,
> | > >
> | > > Peter Yang
> | > > MCSE2000/2003, MCSA, MCDBA
> | > > 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.
> | > >
> | > >
> | > >
> | > >
> | > > --
> | > > | Thread-Topic: RS Activation is failing
> | > > | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==> | > > | X-WBNR-Posting-Host: 84.147.135.4
> | > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | > > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> | > > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> | > > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> | > > | Subject: RE: RS Activation is failing
> | > > | Date: Wed, 4 May 2005 00:08:03 -0700
> | > > | Lines: 23
> | > > | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> | > > | MIME-Version: 1.0
> | > > | Content-Type: text/plain;
> | > > | charset="Utf-8"
> | > > | Content-Transfer-Encoding: 7bit
> | > > | X-Newsreader: Microsoft CDO for Windows 2000
> | > > | Content-Class: urn:content-classes:message
> | > > | Importance: normal
> | > > | Priority: normal
> | > > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:42689
> | > > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > > |
> | > > | 1. I get a successful message when I run the suggested RSACTIVATE
> command
> | > > | 2. When I access http://localhost/reportserver, I get a page with a
> title
> | > > of
> | > > | "Reporting Services Error", and the text is "The report server
> | > > installation
> | > > | is not initialized. Check the documentation for more information.
> | > > | (rsReportServerNotActivated) Get Online Help"
> | > > | 3. I am looged in as local admin, and the administrators group has
> SA
> | > > | privileges on the SQL Server.
> | > > | 4. I have now added the NetworkService account to the local admin
> group,
> | > > as
> | > > | this is the account appearing in the log file (NetzwerkDienst
> stands for
> | > > | NetworkService), I have stopped and restarted the ReportServer
> service,
> | > > and
> | > > | tried the RSACTIVATE again.
> | > > |
> | > > | I'm still having the problem.
> | > > |
> | > > | Also, this a fresh install on Win2003, using Forms Auth as per the
> | > > Microsoft
> | > > | article "Using Forms Authentication in Reporting Services.htm".
> | > > | This setup is working on our current Win 2000 server English, and
> I'm
> | > > trying
> | > > | to upgrade the solution to Win 2003 German. Both RS installations
> are SP1.
> | > > |
> | > > | I have been backing up the RS databases from the win2000 server and
> | > > | restoring them on the win2003, I also copied the encryption key
> across
> | > > using
> | > > | rskeymgmt.
> | > > |
> | > > |
> | > >
> | > >
> ||||Hello,
I agree with you sometimes reinstall might be more effiicient method to
solve this type of issues. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVSHO0o6V3TQIGmTd2mU1ktlKH1tQ==| X-WBNR-Posting-Host: 84.147.137.47
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
<YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
<36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
<nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Activation is failing
| Date: Fri, 6 May 2005 02:21:04 -0700
| Lines: 421
| Message-ID: <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42970
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have restored the rssvrpolicy.config in both directories (ReportServer
and
| ReportManager) and I have the same problem. I didn't find the web.config
file
| from your server that you are mentionning (I don't know where to look for
it).
|
| I'm going to completely reinstall Reporting Services, and I'll also try
to
| get hotfix 821334 as it looks like it may be relevant.
|
| thanks anyway.
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello,
| >
| > It seems the issue is caused by some settings in web.config file.
| >
| > I have included a web.config file on my test machine for your
reference.
| > Please backup the original file on your server, replace with the file
| > attached, and then run iisreset to restart IIS services to test. It is
| > under %programfiles%\Microsoft SQL server\mssql\report
services\reportServer
| >
| > If the issue persists, please double check the rssvrpolicy.config file
to
| > make sure it was not modified properly.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| >
| >
| >
| > --
| > | Thread-Topic: RS Activation is failing
| > | thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw==| > | X-WBNR-Posting-Host: 84.147.136.116
| > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
| > | Subject: RE: RS Activation is failing
| > | Date: Thu, 5 May 2005 03:03:09 -0700
| > | Lines: 274
| > | Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 8bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:42831
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | After looking for this error number on the Web, I found out that it
| > relates
| > | to the encryption keys. I restored a fresh backup from the win2000
| > server,
| > | and copied the encryption keys across using rskeymgmt.
| > |
| > | I can now get to the "Home" page of the RS Manager at URL
| > | http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as
| > soon as
| > | I click on a folder, I get "An internal error occurred on the report
| > server.
| > | See the error log for more details. (rsInternalError) Get Online Help
| > Object
| > | reference not set to an instance of an object."
| > |
| > | The corresponding log file contents are:
| > |
| > | <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_05_2005_11_30_56.log</Path>
| > | <SystemName>TEST</SystemName>
| > | <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
| > | <OSVersion>5.2.3790.0</OSVersion>
| > | </Header>
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration
| > file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > MaxScheduleWait
| > | to default value of '1' second(s) because it was not specified in
| > | Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | DatabaseQueryTimeout to default value of '30' second(s) because it
was
| > not
| > | specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
InstanceName
| > to
| > | default value of 'MSSQLSERVER.1' because it was not specified in
| > | Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | ProcessRecycleOptions to default value of '0' because it was not
| > specified
| > | in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | RunningRequestsScavengerCycle to default value of '30' second(s)
because
| > it
| > | was not specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | RunningRequestsDbCycle to default value of '30' second(s) because it
was
| > not
| > | specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | RunningRequestsAge to default value of '30' second(s) because it was
not
| > | specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | CleanupCycleMinutes to default value of '10' minute(s) because it was
not
| > | specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | SecureConnectionLevel to default value of '1' because it was not
| > specified
| > | in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > DisplayErrorLink
| > | to 'True' as specified in Configuration file.
| > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
| > | WebServiceUseFileShareStorage to default value of 'False' because it
was
| > not
| > | specified in Configuration file.
| > | w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set
to
| > an
| > | instance of an object.
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
| > licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
| > s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
| > secDesc)
| > | at
Microsoft.ReportingServices.Library.Security.GetPermissions(String
| > | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| > | operCollection)
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | -- End of inner exception stack trace --
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | -- End of inner exception stack trace --
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | w3wp!ui!cd4!5/5/2005-11:31:33:: 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.NullReferenceException: Object reference not set
to
| > an
| > | instance of an object.
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo
| > licy(Byte[] secDescBlobStored, Hashtable& secDescHash)
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission
| > s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[]
| > secDesc)
| > | at
Microsoft.ReportingServices.Library.Security.GetPermissions(String
| > | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| > | operCollection)
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | -- End of inner exception stack trace --
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | -- End of inner exception stack trace --
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > |
| > | at
| > |
| >
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
| > Message message, WebResponse response, Stream responseStream, Boolean
| > asyncCall)
| > |
| > | at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| > | methodName, Object[] parameters)
| > |
| > | at
| > |
| >
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
| >
| > | Item)
| > |
| > | at
| > |
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
| > Item)
| > |
| > | at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
| > |
| > | at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
| > |
| > | at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
| > itemPath)
| > |
| > | at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
| > |
| > | at Microsoft.ReportingServices.UI.FolderPage.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!cd4!5/5/2005-11:31:36:: 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)
| > |
| > |
| > | "James" wrote:
| > |
| > | > I have restored the files as per your post, removed anonymous
security
| > for
| > | > the ReportServer and the Reports virtual directories, then
restarted
| > IIS and
| > | > the ReportServer service.
| > | > When I navigate to http://localhost/Reports/ I still experience the
| > same
| > | > problem, and I now get a slightly different error message, with an
| > error
| > | > number at the end of the message:
| > | > The report server installation is not initialized. Check the
| > documentation
| > | > for more information. (rsReportServerNotActivated) Get Online Help
| > | > -2147159550
| > | >
| > | >
| > | > "Peter Yang [MSFT]" wrote:
| > | >
| > | > > Hello,
| > | > >
| > | > > It seems to be issue caused by that form authentication was not
| > configured
| > | > > properly. Please try to use Windows authentication (default
| > configuration)
| > | > > to make sure it works properly. You could refer to the following
| > | > > information from "Using Forms Authentication in Reporting
Services"
| > link.
| > | > >
| > | > > Removing the Sample Extension
| > | > > While not generally recommended, it is possible to revert back to
| > Windows
| > | > > Authentication after you have tried out the sample. To revert to
| > Windows
| > | > > security, do the following:
| > | > >
| > | > > Restore the following files from your backup copies: Web.config,
| > | > > RSReportServer.config, and RSWebApplication.config. This should
set
| > the
| > | > > authentication and authorization methods for the report server to
the
| > | > > default Windows security. This should also remove any entries you
| > made for
| > | > > your extension in the Report Server or Report Manager
configuration
| > files.
| > | > >
| > | > > Disable anonymous access in Internet Information Services (IIS)
for
| > the
| > | > > report server virtual directory.
| > | > >
| > | > > If it works at this time, you may try to configure form
| > authenctication
| > | > > again to troubleshoot the original issue.
| > | > >
| > | > > Regards,
| > | > >
| > | > > Peter Yang
| > | > > MCSE2000/2003, MCSA, MCDBA
| > | > > 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.
| > | > >
| > | > >
| > | > >
| > | > >
| > | > > --
| > | > > | Thread-Topic: RS Activation is failing
| > | > > | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ==| > | > > | X-WBNR-Posting-Host: 84.147.135.4
| > | > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > | > > | References:
<8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > | > > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > | > > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > | > > | Subject: RE: RS Activation is failing
| > | > > | Date: Wed, 4 May 2005 00:08:03 -0700
| > | > > | Lines: 23
| > | > > | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > | > > | MIME-Version: 1.0
| > | > > | Content-Type: text/plain;
| > | > > | charset="Utf-8"
| > | > > | Content-Transfer-Encoding: 7bit
| > | > > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > > | Content-Class: urn:content-classes:message
| > | > > | Importance: normal
| > | > > | Priority: normal
| > | > > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | > > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > > | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:42689
| > | > > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > > |
| > | > > | 1. I get a successful message when I run the suggested
RSACTIVATE
| > command
| > | > > | 2. When I access http://localhost/reportserver, I get a page
with a
| > title
| > | > > of
| > | > > | "Reporting Services Error", and the text is "The report server
| > | > > installation
| > | > > | is not initialized. Check the documentation for more
information.
| > | > > | (rsReportServerNotActivated) Get Online Help"
| > | > > | 3. I am looged in as local admin, and the administrators group
has
| > SA
| > | > > | privileges on the SQL Server.
| > | > > | 4. I have now added the NetworkService account to the local
admin
| > group,
| > | > > as
| > | > > | this is the account appearing in the log file (NetzwerkDienst
| > stands for
| > | > > | NetworkService), I have stopped and restarted the ReportServer
| > service,
| > | > > and
| > | > > | tried the RSACTIVATE again.
| > | > > |
| > | > > | I'm still having the problem.
| > | > > |
| > | > > | Also, this a fresh install on Win2003, using Forms Auth as per
the
| > | > > Microsoft
| > | > > | article "Using Forms Authentication in Reporting Services.htm".
| > | > > | This setup is working on our current Win 2000 server English,
and
| > I'm
| > | > > trying
| > | > > | to upgrade the solution to Win 2003 German. Both RS
installations
| > are SP1.
| > | > > |
| > | > > | I have been backing up the RS databases from the win2000 server
and
| > | > > | restoring them on the win2003, I also copied the encryption key
| > across
| > | > > using
| > | > > | rskeymgmt.
| > | > > |
| > | > > |
| > | > >
| > | > >
| > |
||||I'm still having the same problem.
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'm still getting the same error:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)
I ran rsactivate as per your first post, 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?
Here is the log:
<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>HERAS10TEST</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
--Details--
CantCommunicateWithReportServerException: Unable to communicate with report
server. Please verify that the report server is operational.
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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!ac!5/9/2005-14:33:38:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
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.GetPermissions(String
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
at Microsoft.ReportingServices.UI.FolderPage.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!ac!5/9/2005-14:33:38:: 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)|||Hello,
I thought you have followed the following KB to move database between
servers.
842425 How to move a Reporting Services database from a computer that is
http://support.microsoft.com/?id=842425
If it is the case, the issue might be related to Windows 2000 uses ASP.net
account while Windows 2003 uses Network Service account in Application
pool. You may want to add Network service account with proper permssion to
reportserver databases to see if it helps.
Also, I 'm not quite sure if German OS shall bring issues. You may want to
call local CSS to confirm this but I personally don't think it shall be a
issue. You may compare collation settings between databases on different
servers.
Different computer name shall not be a problem here.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg==| X-WBNR-Posting-Host: 84.147.167.79
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
<YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
<36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
<nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
<6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
<xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Activation is failing
| Date: Mon, 9 May 2005 05:40:05 -0700
| Lines: 246
| Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43161
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm still having the same problem.
| 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'm still getting the same error:
| The report server installation is not initialized. Check the
documentation
| for more information. (rsReportServerNotActivated)
|
| I ran rsactivate as per your first post, 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?
|
| Here is the log:
|
| <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>HERAS10TEST</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
| --Details--
| CantCommunicateWithReportServerException: Unable to communicate with
report
| server. Please verify that the report server is operational.
|
| 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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
| System.Web.Services.Protocols.SoapException: The report server
installation
| is not initialized. Check the documentation for more information. -->
|
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception:
| The report server installation is not initialized. Check the
documentation
| for more information.
| at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
| at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
| at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
| at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
| at Microsoft.ReportingServices.Library.Storage.get_Connection()
| at
| Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
| storedProcedureName)
| at
|
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
| at
|
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
| at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
| name)
| at
|
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
| at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
| at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
| source)
| at
| Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| path, Boolean validate, Boolean convert, Boolean translate)
| at
| Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| path)
| at
|
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
ator pathTranslator, String userSuppliedPath, String parameterName)
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| -- End of inner exception stack trace --
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| w3wp!ui!ac!5/9/2005-14:33:38:: e ERROR: HTTP status code --> 200
| --Details--
| System.Web.Services.Protocols.SoapException:
| System.Web.Services.Protocols.SoapException: The report server
installation
| is not initialized. Check the documentation for more information. -->
|
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception:
| The report server installation is not initialized. Check the
documentation
| for more information.
| at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
| at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
| at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
| at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
| at Microsoft.ReportingServices.Library.Storage.get_Connection()
| at
| Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
| storedProcedureName)
| at
|
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
| at
|
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
| at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
| name)
| at
|
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
| at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
| at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
| source)
| at
| Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| path, Boolean validate, Boolean convert, Boolean translate)
| at
| Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| path)
| at
|
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
ator pathTranslator, String userSuppliedPath, String parameterName)
| at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
| -- End of inner exception stack trace --
| at
|
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| Item, String[]& Permissions)
|
| at
|
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall)
|
| at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| methodName, Object[] parameters)
|
| at
|
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
| Item)
|
| at
| Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
Item)
|
| at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
|
| at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
|
| at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
itemPath)
|
| at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
|
| at Microsoft.ReportingServices.UI.FolderPage.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!ac!5/9/2005-14:33:38:: 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)
|
|
||||OK. I just opened a support case with MS Germany.
"Peter Yang [MSFT]" wrote:
> Hello,
> I thought you have followed the following KB to move database between
> servers.
> 842425 How to move a Reporting Services database from a computer that is
> http://support.microsoft.com/?id=842425
> If it is the case, the issue might be related to Windows 2000 uses ASP.net
> account while Windows 2003 uses Network Service account in Application
> pool. You may want to add Network service account with proper permssion to
> reportserver databases to see if it helps.
> Also, I 'm not quite sure if German OS shall bring issues. You may want to
> call local CSS to confirm this but I personally don't think it shall be a
> issue. You may compare collation settings between databases on different
> servers.
> Different computer name shall not be a problem here.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
>
> --
> | Thread-Topic: RS Activation is failing
> | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg==> | X-WBNR-Posting-Host: 84.147.167.79
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
> <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
> <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
> <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
> <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: RS Activation is failing
> | Date: Mon, 9 May 2005 05:40:05 -0700
> | Lines: 246
> | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43161
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm still having the same problem.
> | 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'm still getting the same error:
> | The report server installation is not initialized. Check the
> documentation
> | for more information. (rsReportServerNotActivated)
> |
> | I ran rsactivate as per your first post, 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?
> |
> | Here is the log:
> |
> | <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>HERAS10TEST</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
> | --Details--
> | CantCommunicateWithReportServerException: Unable to communicate with
> report
> | server. Please verify that the report server is operational.
> |
> | 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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
> | System.Web.Services.Protocols.SoapException: The report server
> installation
> | is not initialized. Check the documentation for more information. -->
> |
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception:
> | The report server installation is not initialized. Check the
> documentation
> | for more information.
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> | at Microsoft.ReportingServices.Library.Storage.get_Connection()
> | at
> | Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> | storedProcedureName)
> | at
> |
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> | at
> |
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> | at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> | name)
> | at
> |
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> | at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> | at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> | source)
> | at
> | Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> | path, Boolean validate, Boolean convert, Boolean translate)
> | at
> | Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> | path)
> | at
> |
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
> ator pathTranslator, String userSuppliedPath, String parameterName)
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | -- End of inner exception stack trace --
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | w3wp!ui!ac!5/9/2005-14:33:38:: e ERROR: HTTP status code --> 200
> | --Details--
> | System.Web.Services.Protocols.SoapException:
> | System.Web.Services.Protocols.SoapException: The report server
> installation
> | is not initialized. Check the documentation for more information. -->
> |
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception:
> | The report server installation is not initialized. Check the
> documentation
> | for more information.
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> | at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> | at Microsoft.ReportingServices.Library.Storage.get_Connection()
> | at
> | Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> | storedProcedureName)
> | at
> |
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> | at
> |
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> | at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> | name)
> | at
> |
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> | at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> | at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> | source)
> | at
> | Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> | path, Boolean validate, Boolean convert, Boolean translate)
> | at
> | Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> | path)
> | at
> |
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
> ator pathTranslator, String userSuppliedPath, String parameterName)
> | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> | -- End of inner exception stack trace --
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> | Item, String[]& Permissions)
> |
> | at
> |
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> |
> | at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> | methodName, Object[] parameters)
> |
> | at
> |
> Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> | Item)
> |
> | at
> | Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
> Item)
> |
> | at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> |
> | at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
> |
> | at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
> itemPath)
> |
> | at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
> |
> | at Microsoft.ReportingServices.UI.FolderPage.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!ac!5/9/2005-14:33:38:: 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)
> |
> |
> |
>|||Hello,
If you have any update, you may want to post back in the newsgroup. I am
sure it shall benefit the community.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA==| X-WBNR-Posting-Host: 84.56.12.223
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
<YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
<36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
<nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
<6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
<xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
<2ni8NYTVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Activation is failing
| Date: Wed, 11 May 2005 04:00:01 -0700
| Lines: 394
| Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43405
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| OK. I just opened a support case with MS Germany.
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello,
| >
| > I thought you have followed the following KB to move database between
| > servers.
| >
| > 842425 How to move a Reporting Services database from a computer that is
| > http://support.microsoft.com/?id=842425
| >
| > If it is the case, the issue might be related to Windows 2000 uses
ASP.net
| > account while Windows 2003 uses Network Service account in Application
| > pool. You may want to add Network service account with proper permssion
to
| > reportserver databases to see if it helps.
| >
| > Also, I 'm not quite sure if German OS shall bring issues. You may want
to
| > call local CSS to confirm this but I personally don't think it shall be
a
| > issue. You may compare collation settings between databases on
different
| > servers.
| >
| > Different computer name shall not be a problem here.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| >
| >
| >
| > --
| > | Thread-Topic: RS Activation is failing
| > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg==| > | X-WBNR-Posting-Host: 84.147.167.79
| > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
| > <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
| > <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
| > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
| > <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > | Subject: RE: RS Activation is failing
| > | Date: Mon, 9 May 2005 05:40:05 -0700
| > | Lines: 246
| > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 8bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43161
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I'm still having the same problem.
| > | 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'm still getting the same error:
| > | The report server installation is not initialized. Check the
| > documentation
| > | for more information. (rsReportServerNotActivated)
| > |
| > | I ran rsactivate as per your first post, 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?
| > |
| > | Here is the log:
| > |
| > | <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>HERAS10TEST</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
| > | --Details--
| > | CantCommunicateWithReportServerException: Unable to communicate with
| > report
| > | server. Please verify that the report server is operational.
| > |
| > | 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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
| > | System.Web.Services.Protocols.SoapException: The report server
| > installation
| > | is not initialized. Check the documentation for more information.
-->
| > |
| >
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
| > ception:
| > | The report server installation is not initialized. Check the
| > documentation
| > | for more information.
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
| > | at Microsoft.ReportingServices.Library.Storage.get_Connection()
| > | at
| > |
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
| > | storedProcedureName)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
| > ng key)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
| > (String name)
| > | at
| > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
| > | name)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
| > ng name)
| > | at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
| > | at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
| > | source)
| > | at
| > |
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| > | path, Boolean validate, Boolean convert, Boolean translate)
| > | at
| > |
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| > | path)
| > | at
| > |
| >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
| > ator pathTranslator, String userSuppliedPath, String parameterName)
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | -- End of inner exception stack trace --
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | w3wp!ui!ac!5/9/2005-14:33:38:: e ERROR: HTTP status code --> 200
| > | --Details--
| > | System.Web.Services.Protocols.SoapException:
| > | System.Web.Services.Protocols.SoapException: The report server
| > installation
| > | is not initialized. Check the documentation for more information.
-->
| > |
| >
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
| > ception:
| > | The report server installation is not initialized. Check the
| > documentation
| > | for more information.
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
| > | at
| > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
| > | at Microsoft.ReportingServices.Library.Storage.get_Connection()
| > | at
| > |
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
| > | storedProcedureName)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
| > ng key)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
| > (String name)
| > | at
| > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
| > | name)
| > | at
| > |
| >
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
| > ng name)
| > | at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
| > | at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
| > | source)
| > | at
| > |
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| > | path, Boolean validate, Boolean convert, Boolean translate)
| > | at
| > |
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
| > | path)
| > | at
| > |
| >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTransl
| > ator pathTranslator, String userSuppliedPath, String parameterName)
| > | at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > | -- End of inner exception stack trace --
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
| >
| > | Item, String[]& Permissions)
| > |
| > | at
| > |
| >
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
| > Message message, WebResponse response, Stream responseStream, Boolean
| > asyncCall)
| > |
| > | at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| > | methodName, Object[] parameters)
| > |
| > | at
| > |
| >
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
| >
| > | Item)
| > |
| > | at
| > |
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
| > Item)
| > |
| > | at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
| > |
| > | at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
| > |
| > | at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
| > itemPath)
| > |
| > | at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
| > |
| > | at Microsoft.ReportingServices.UI.FolderPage.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!ac!5/9/2005-14:33:38:: 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 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.
"Peter Yang [MSFT]" wrote:
> Hello,
> If you have any update, you may want to post back in the newsgroup. I am
> sure it shall benefit the community.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
>
> --
> | Thread-Topic: RS Activation is failing
> | thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA==> | X-WBNR-Posting-Host: 84.56.12.223
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
> <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
> <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
> <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
> <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
> <2ni8NYTVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: RS Activation is failing
> | Date: Wed, 11 May 2005 04:00:01 -0700
> | Lines: 394
> | Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43405
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | OK. I just opened a support case with MS Germany.
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello,
> | >
> | > I thought you have followed the following KB to move database between
> | > servers.
> | >
> | > 842425 How to move a Reporting Services database from a computer that is
> | > http://support.microsoft.com/?id=842425
> | >
> | > If it is the case, the issue might be related to Windows 2000 uses
> ASP.net
> | > account while Windows 2003 uses Network Service account in Application
> | > pool. You may want to add Network service account with proper permssion
> to
> | > reportserver databases to see if it helps.
> | >
> | > Also, I 'm not quite sure if German OS shall bring issues. You may want
> to
> | > call local CSS to confirm this but I personally don't think it shall be
> a
> | > issue. You may compare collation settings between databases on
> different
> | > servers.
> | >
> | > Different computer name shall not be a problem here.
> | >
> | > Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > 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.
> | >
> | >
> | >
> | >
> | > --
> | > | Thread-Topic: RS Activation is failing
> | > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg==> | > | X-WBNR-Posting-Host: 84.147.167.79
> | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
> | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
> | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
> | > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
> | > <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
> | > <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
> | > <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
> | > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
> | > <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
> | > | Subject: RE: RS Activation is failing
> | > | Date: Mon, 9 May 2005 05:40:05 -0700
> | > | Lines: 246
> | > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 8bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:43161
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | I'm still having the same problem.
> | > | 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'm still getting the same error:
> | > | The report server installation is not initialized. Check the
> | > documentation
> | > | for more information. (rsReportServerNotActivated)
> | > |
> | > | I ran rsactivate as per your first post, 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?
> | > |
> | > | Here is the log:
> | > |
> | > | <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>HERAS10TEST</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
> | > | --Details--
> | > | CantCommunicateWithReportServerException: Unable to communicate with
> | > report
> | > | server. Please verify that the report server is operational.
> | > |
> | > | 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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
> | > | System.Web.Services.Protocols.SoapException: The report server
> | > installation
> | > | is not initialized. Check the documentation for more information.
> -->
> | > |
> | >
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> | > ception:
> | > | The report server installation is not initialized. Check the
> | > documentation|||Great to hear you find the resolution!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: RS Activation is failing
| thread-index: AcVi0T9SlXafG/0OSkGCjJHxspjndg==| X-WBNR-Posting-Host: 84.147.150.94
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
<DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
<EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
<YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
<36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
<nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
<6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
<xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
<38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
<2ni8NYTVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
<FAC3D018-70FA-45BE-9FB6-3978E62C8BED@.microsoft.com>
<l#A8gfpVFHA.460@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Activation is failing
| Date: Fri, 27 May 2005 08:32:10 -0700
| Lines: 313
| Message-ID: <FB215117-2B1A-485E-A705-D35E48D72827@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:44903
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 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.
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello,
| >
| > If you have any update, you may want to post back in the newsgroup. I
am
| > sure it shall benefit the community.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| >
| >
| >
| > --
| > | Thread-Topic: RS Activation is failing
| > | thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA==| > | X-WBNR-Posting-Host: 84.56.12.223
| > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
| > <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
| > <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
| > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
| > <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
| > <2ni8NYTVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
| > | Subject: RE: RS Activation is failing
| > | Date: Wed, 11 May 2005 04:00:01 -0700
| > | Lines: 394
| > | Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 8bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43405
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | OK. I just opened a support case with MS Germany.
| > |
| > | "Peter Yang [MSFT]" wrote:
| > |
| > | > Hello,
| > | >
| > | > I thought you have followed the following KB to move database
between
| > | > servers.
| > | >
| > | > 842425 How to move a Reporting Services database from a computer
that is
| > | > http://support.microsoft.com/?id=842425
| > | >
| > | > If it is the case, the issue might be related to Windows 2000 uses
| > ASP.net
| > | > account while Windows 2003 uses Network Service account in
Application
| > | > pool. You may want to add Network service account with proper
permssion
| > to
| > | > reportserver databases to see if it helps.
| > | >
| > | > Also, I 'm not quite sure if German OS shall bring issues. You may
want
| > to
| > | > call local CSS to confirm this but I personally don't think it
shall be
| > a
| > | > issue. You may compare collation settings between databases on
| > different
| > | > servers.
| > | >
| > | > Different computer name shall not be a problem here.
| > | >
| > | > Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > 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.
| > | >
| > | >
| > | >
| > | >
| > | > --
| > | > | Thread-Topic: RS Activation is failing
| > | > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg==| > | > | X-WBNR-Posting-Host: 84.147.167.79
| > | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@.nospam.nospam>
| > | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@.microsoft.com>
| > | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@.microsoft.com>
| > | > <EutxrsFUFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| > | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@.microsoft.com>
| > | > <YChiBASUFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@.microsoft.com>
| > | > <36C317C7-B231-43E9-A5A3-C0325D7822DE@.microsoft.com>
| > | > <nPaDQMgUFHA.3336@.TK2MSFTNGXA01.phx.gbl>
| > | > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@.microsoft.com>
| > | > <xY$u8RFVFHA.2184@.TK2MSFTNGXA01.phx.gbl>
| > | > | Subject: RE: RS Activation is failing
| > | > | Date: Mon, 9 May 2005 05:40:05 -0700
| > | > | Lines: 246
| > | > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@.microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 8bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:43161
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | I'm still having the same problem.
| > | > | 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'm still getting the same error:
| > | > | The report server installation is not initialized. Check the
| > | > documentation
| > | > | for more information. (rsReportServerNotActivated)
| > | > |
| > | > | I ran rsactivate as per your first post, 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?
| > | > |
| > | > | Here is the log:
| > | > |
| > | > | <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>HERAS10TEST</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
| > | > | --Details--
| > | > | CantCommunicateWithReportServerException: Unable to communicate
with
| > | > report
| > | > | server. Please verify that the report server is operational.
| > | > |
| > | > | 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!ac!5/9/2005-14:33:19:: 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!ac!5/9/2005-14:33:38:: e ERROR:
| > | > | System.Web.Services.Protocols.SoapException: The report server
| > | > installation
| > | > | is not initialized. Check the documentation for more information.
| > -->
| > | > |
| > | >
| >
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
| > | > ception:
| > | > | The report server installation is not initialized. Check the
| > | > documentation
|
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment