|
Home > Archive > MS SQL Server Reporting Services > May 2005 > RS Activation is failing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RS Activation is failing
|
|
|
| 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\Microso
ft SQL Server\MSSQL\Reporti
ng
Services\LogFiles\Re
portServer__05_03_20
05_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!0
3.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
IsNotificationServic
e 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
MaxAppDomainUnloadTi
me 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
MaxActiveReqForOneUs
er 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
ProcessRecycleOption
s to '0' as specified in Configuration file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
RunningRequestsScave
ngerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing
RunningRequestsDbCyc
le 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
SecureConnectionLeve
l 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
WebServiceUseFileSha
reStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutiliti
es!b98!03.05.2005-20:36:09:: i INFO: Running on 0
physical processors, 1 logical processors
w3wp!resourceutiliti
es!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\NETZWERKD
IENST
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. ReportServerNotActiv
atedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities. ReportServerNotActiv
atedException:
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\NETZWERKD
IENST
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. ReportServerNotActiv
atedException:
Die Installation des Berichtsservers ist nicht initialisiert. Weitere
Informationen finden Sie in der Dokumentation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities. ReportServerNotActiv
atedException:
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.
| |
| Peter Yang [MSFT] 2005-05-04, 3:24 am |
| 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\Reporti
ng
Services\ReportServe
r\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: AcVQFpoaVsyfZVL4RFuX
yA0cnTIbaQ==
| X-WBNR-Posting-Host: 145.254.231.5
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.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@microso
ft.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.
(rsReportServerNotAc
tivated) 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.
| |
| Peter Yang [MSFT] 2005-05-05, 3:23 am |
| 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: AcVQeAOPobWAMXOUQ8iH
HiHYJ2+4CQ==
| X-WBNR-Posting-Host: 84.147.135.4
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
<DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.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@microso
ft.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.
| (rsReportServerNotAc
tivated) 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. (rsReportServerNotAc
tivated) 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: AcVQeAOPobWAMXOUQ8iH
HiHYJ2+4CQ==
> | X-WBNR-Posting-Host: 84.147.135.4
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
> <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.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@microso
ft.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.
> | (rsReportServerNotAc
tivated) 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
[url]http://localhost/Reports/Pages/Folder.aspx? IsDetailsView=True,[
/url] 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\Microso
ft SQL Server\MSSQL\Reporti
ng
Services\LogFiles\Re
portServerWebApp__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
MaxActiveReqForOneUs
er 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
ProcessRecycleOption
s 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
RunningRequestsScave
ngerCycle 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
RunningRequestsDbCyc
le 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
SecureConnectionLeve
l 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
WebServiceUseFileSha
reStorage 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. InternalCatalogExcep
tion:
An internal error occurred on the report server. See the error log for more
details. ---> System. NullReferenceExcepti
on: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash)
at
Microsoft.ReportingServices.Authorization. WindowsAuthorization
. GetPermissions(Strin
g userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security. GetPermissions(Strin
g
itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
operCollection)
at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
item, StringCollection& Operations)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
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. InternalCatalogExcep
tion:
An internal error occurred on the report server. See the error log for more
details. ---> System. NullReferenceExcepti
on: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash)
at
Microsoft.ReportingServices.Authorization. WindowsAuthorization
. GetPermissions(Strin
g userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc)
at Microsoft.ReportingServices.Library.Security. GetPermissions(Strin
g
itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
operCollection)
at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
item, StringCollection& Operations)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
at
System.Web.Services.Protocols. SoapHttpClientProtoc
ol. ReadResponse(SoapCli
entMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols. SoapHttpClientProtoc
ol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService. GetPermissions(Strin
g
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection. GetPermissions(Strin
g 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(Contro
l 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:
[color=darkred]
> 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. (rsReportServerNotAc
tivated) Get Online Help
> -2147159550
>
>
> "Peter Yang [MSFT]" wrote:
>
| |
| Peter Yang [MSFT] 2005-05-06, 3:23 am |
| 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%\Micro
soft SQL server\mssql\report services\reportServe
r
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: AcVRWaOuBQFMWf7jRZau
SM4LB2CPuw==
| X-WBNR-Posting-Host: 84.147.136.116
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
<DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.com>
<EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394- 82ECD304367E@microso
ft.com>
<YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E- 4D5992026577@microso
ft.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@microso
ft.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
| [url]http://localhost/Reports/Pages/Folder.aspx? IsDetailsView=True,[
/url] 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\Microso
ft SQL Server\MSSQL\Reporti
ng
| Services\LogFiles\Re
portServerWebApp__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
| MaxActiveReqForOneUs
er 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
| ProcessRecycleOption
s 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
| RunningRequestsScave
ngerCycle 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
| RunningRequestsDbCyc
le 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
| SecureConnectionLeve
l 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
| WebServiceUseFileSha
reStorage 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. InternalCatalogExcep
tion:
| An internal error occurred on the report server. See the error log for
more
| details. ---> System. NullReferenceExcepti
on: Object reference not set to
an
| instance of an object.
| at
|
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
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(Strin
g
| itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| operCollection)
| at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| item, StringCollection& Operations)
| --- End of inner exception stack trace ---
| at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| Item, String[]& Permissions)
| --- End of inner exception stack trace ---
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| 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. InternalCatalogExcep
tion:
| An internal error occurred on the report server. See the error log for
more
| details. ---> System. NullReferenceExcepti
on: Object reference not set to
an
| instance of an object.
| at
|
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
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(Strin
g
| itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| operCollection)
| at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| item, StringCollection& Operations)
| --- End of inner exception stack trace ---
| at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| Item, String[]& Permissions)
| --- End of inner exception stack trace ---
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| Item, String[]& Permissions)
|
| at
|
System.Web.Services.Protocols. SoapHttpClientProtoc
ol. ReadResponse(SoapCli
ent
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall)
|
| at System.Web.Services.Protocols. SoapHttpClientProtoc
ol.Invoke(String
| methodName, Object[] parameters)
|
| at
|
Microsoft.SqlServer.ReportingServices.ReportingService. GetPermissions(Strin
g
| Item)
|
| at
| Microsoft.SqlServer.ReportingServices.RSConnection. GetPermissions(Strin
g
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(Contro
l 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. (rsReportServerNotAc
tivated) 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: AcVQeAOPobWAMXOUQ8iH
HiHYJ2+4CQ==
| > > | X-WBNR-Posting-Host: 84.147.135.4
| > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| > > | References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
| > > <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.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@microso
ft.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.
| > > | (rsReportServerNotAc
tivated) 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 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%\Micro
soft SQL server\mssql\report services\reportServe
r
>
> 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: AcVRWaOuBQFMWf7jRZau
SM4LB2CPuw==
> | X-WBNR-Posting-Host: 84.147.136.116
> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
> | References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
> <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.com>
> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl>
> <703E5FCD-3BD0-41BF-8394- 82ECD304367E@microso
ft.com>
> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl>
> <E21F36EB-AABE-4EE0-9D7E- 4D5992026577@microso
ft.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@microso
ft.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
> | [url]http://localhost/Reports/Pages/Folder.aspx? IsDetailsView=True,[
/url] 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\Microso
ft SQL Server\MSSQL\Reporti
ng
> | Services\LogFiles\Re
portServerWebApp__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
> | MaxActiveReqForOneUs
er 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
> | ProcessRecycleOption
s 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
> | RunningRequestsScave
ngerCycle 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
> | RunningRequestsDbCyc
le 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
> | SecureConnectionLeve
l 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
> | WebServiceUseFileSha
reStorage 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. InternalCatalogExcep
tion:
> | An internal error occurred on the report server. See the error log for
> more
> | details. ---> System. NullReferenceExcepti
on: Object reference not set to
> an
> | instance of an object.
> | at
> |
> Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
> 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(Strin
g
> | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
> | operCollection)
> | at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
> | item, StringCollection& Operations)
> | --- End of inner exception stack trace ---
> | at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
>
> | Item, String[]& Permissions)
> | --- End of inner exception stack trace ---
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
>
> | 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. InternalCatalogExcep
tion:
> | An internal error occurred on the report server. See the error log for
> more
> | details. ---> System. NullReferenceExcepti
on: Object reference not set to
> an
> | instance of an object.
> | at
> |
> Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
> 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(Strin
g
> | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
> | operCollection)
> | at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
> | item, StringCollection& Operations)
> | --- End of inner exception stack trace ---
> | at Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
> | item, StringCollection& Operations)
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
>
> | Item, String[]& Permissions)
> | --- End of inner exception stack trace ---
> | at
> |
> Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
>
> | Item, String[]& Permissions)
> |
> | at
> |
> System.Web.Services.Protocols. SoapHttpClientProtoc
ol. ReadResponse(SoapCli
ent
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> |
> | at System.Web.Services.Protocols. SoapHttpClientProtoc
ol.Invoke(String
> | methodName, Object[] parameters)
> |
> | at
> |
> Microsoft.SqlServer.ReportingServices.ReportingService. GetPermissions(Strin
g
>
> | Item)
> |
> | at
> | Microsoft.SqlServer.ReportingServices.RSConnection. GetPermissions(Strin
g
> 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(Contro
l 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. (rsReportServerNotAc
tivated) 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: AcVQeAOPobWAMXOUQ8iH
HiHYJ2+4CQ==
> | > > | X-WBNR-Posting-Host: 84.147.135.4
> | > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
> | > > | References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
> | > > <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.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@microso
ft.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.
> | > > | (rsReportServerNotAc
tivated) 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.
> | > > |
> | > > |
> | > >
> | > >
> |
| |
| Peter Yang [MSFT] 2005-05-09, 3:23 am |
| 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: AcVSHO0o6V3TQIGmTd2m
U1ktlKH1tQ==
| X-WBNR-Posting-Host: 84.147.137.47
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
<DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.com>
<EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394- 82ECD304367E@microso
ft.com>
<YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E- 4D5992026577@microso
ft.com>
<36C317C7-B231-43E9-A5A3- C0325D7822DE@microso
ft.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@microso
ft.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%\Micro
soft SQL server\mssql\report
services\reportServe
r
| >
| > 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: AcVRWaOuBQFMWf7jRZau
SM4LB2CPuw==
| > | X-WBNR-Posting-Host: 84.147.136.116
| > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| > | References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
| > <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.com>
| > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl>
| > <703E5FCD-3BD0-41BF-8394- 82ECD304367E@microso
ft.com>
| > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl>
| > <E21F36EB-AABE-4EE0-9D7E- 4D5992026577@microso
ft.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@microso
ft.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
| > | [url]http://localhost/Reports/Pages/Folder.aspx? IsDetailsView=True,[
/url] 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\Microso
ft SQL Server\MSSQL\Reporti
ng
| > | Services\LogFiles\Re
portServerWebApp__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
| > | MaxActiveReqForOneUs
er 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
| > | ProcessRecycleOption
s 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
| > | RunningRequestsScave
ngerCycle 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
| > | RunningRequestsDbCyc
le 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
| > | SecureConnectionLeve
l 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
| > | WebServiceUseFileSha
reStorage 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. InternalCatalogExcep
tion:
| > | An internal error occurred on the report server. See the error log
for
| > more
| > | details. ---> System. NullReferenceExcepti
on: Object reference not set
to
| > an
| > | instance of an object.
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
| > 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(Strin
g
| > | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| > | operCollection)
| > | at
Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| > | item, StringCollection& Operations)
| > | --- End of inner exception stack trace ---
| > | at
Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| >
| > | Item, String[]& Permissions)
| > | --- End of inner exception stack trace ---
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| >
| > | 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. InternalCatalogExcep
tion:
| > | An internal error occurred on the report server. See the error log
for
| > more
| > | details. ---> System. NullReferenceExcepti
on: Object reference not set
to
| > an
| > | instance of an object.
| > | at
| > |
| >
Microsoft.ReportingServices.Authorization.SdAndType. PrepareToRestoreBina
ryPo
| > 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(Strin
g
| > | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
| > | operCollection)
| > | at
Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| > | item, StringCollection& Operations)
| > | --- End of inner exception stack trace ---
| > | at
Microsoft.ReportingServices.Library.RSService. GetPermissions(Strin
g
| > | item, StringCollection& Operations)
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| >
| > | Item, String[]& Permissions)
| > | --- End of inner exception stack trace ---
| > | at
| > |
| >
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| >
| > | Item, String[]& Permissions)
| > |
| > | at
| > |
| >
System.Web.Services.Protocols. SoapHttpClientProtoc
ol. ReadResponse(SoapCli
ent
| > Message message, WebResponse response, Stream responseStream, Boolean
| > asyncCall)
| > |
| > | at
System.Web.Services.Protocols. SoapHttpClientProtoc
ol.Invoke(String
| > | methodName, Object[] parameters)
| > |
| > | at
| > |
| >
Microsoft.SqlServer.ReportingServices.ReportingService. GetPermissions(Strin
g
| >
| > | Item)
| > |
| > | at
| > |
Microsoft.SqlServer.ReportingServices.RSConnection. GetPermissions(Strin
g
| > 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(Contro
l 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. (rsReportServerNotAc
tivated) 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: AcVQeAOPobWAMXOUQ8iH
HiHYJ2+4CQ==
| > | > > | X-WBNR-Posting-Host: 84.147.135.4
| > | > > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| > | > > | References:
<8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
| > | > > <DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.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@microso
ft.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.
| > | > > | (rsReportServerNotAc
tivated) 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. (rsReportServerNotAc
tivated)
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\Microso
ft SQL Server\MSSQL\Reporti
ng
Services\LogFiles\Re
portServerWebApp__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
MaxActiveReqForOneUs
er 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
ProcessRecycleOption
s 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
RunningRequestsScave
ngerCycle 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
RunningRequestsDbCyc
le 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
SecureConnectionLeve
l 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
WebServiceUseFileSha
reStorage 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--------
CantCommunicateWithR
eportServerException
: 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(Strin
g
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage. EnsureHttpsLevel(Htt
psLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage. ReportingPage_Init(O
bject
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(Contro
l 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. ReportServerNotActiv
atedException:
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. NewStandardSqlComman
d(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface. GetOneConfigurationI
nfo(String key)
at
Microsoft.ReportingServices.Library. CachedSystemProperti
es. GetSystemProperty(St
ring name)
at Microsoft.ReportingServices.Library. CachedSystemProperti
es.Get(String
name)
at
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService. get_MyReportsEnabled
()
at Microsoft.ReportingServices.Library.RSService. PathToInternal(Strin
g
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(Strin
g
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
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. ReportServerNotActiv
atedException:
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. NewStandardSqlComman
d(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface. GetOneConfigurationI
nfo(String key)
at
Microsoft.ReportingServices.Library. CachedSystemProperti
es. GetSystemProperty(St
ring name)
at Microsoft.ReportingServices.Library. CachedSystemProperti
es.Get(String
name)
at
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService. get_MyReportsEnabled
()
at Microsoft.ReportingServices.Library.RSService. PathToInternal(Strin
g
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(Strin
g
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
Item, String[]& Permissions)
at
System.Web.Services.Protocols. SoapHttpClientProtoc
ol. ReadResponse(SoapCli
entMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols. SoapHttpClientProtoc
ol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService. GetPermissions(Strin
g
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection. GetPermissions(Strin
g 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(Contro
l 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)
| |
| Peter Yang [MSFT] 2005-05-10, 3:23 am |
| 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+04NSR2T6RyaK
WWnSC8aHtg==
| X-WBNR-Posting-Host: 84.147.167.79
| From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
| References: <8A324CAC-F186-4ECD-9D1A- 5ADEAF6AAF91@microso
ft.com>
<DABDE5FC-2D14-4659-9617- E13FDDDD7688@microso
ft.com>
<EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl>
<703E5FCD-3BD0-41BF-8394- 82ECD304367E@microso
ft.com>
<YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl>
<E21F36EB-AABE-4EE0-9D7E- 4D5992026577@microso
ft.com>
<36C317C7-B231-43E9-A5A3- C0325D7822DE@microso
ft.com>
<nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl>
<6F989D22-2C10-4616-89D5- 1C86B9E2ACDA@microso
ft.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@microso
ft.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. (rsReportServerNotAc
tivated)
|
| 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\Microso
ft SQL Server\MSSQL\Reporti
ng
| Services\LogFiles\Re
portServerWebApp__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
| MaxActiveReqForOneUs
er 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
| ProcessRecycleOption
s 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
| RunningRequestsScave
ngerCycle 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
| RunningRequestsDbCyc
le 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
| SecureConnectionLeve
l 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
| WebServiceUseFileSha
reStorage 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--------
| CantCommunicateWithR
eportServerException
: 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(Strin
g
| methodname)
|
| at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
|
| at
| Microsoft.ReportingServices.UI.ReportingPage. EnsureHttpsLevel(Htt
psLevel
| level)
|
| at
Microsoft.ReportingServices.UI.ReportingPage. ReportingPage_Init(O
bject
| 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(Contro
l 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. ReportServerNotActiv
atedEx
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. NewStandardSqlComman
d(String
| storedProcedureName)
| at
|
Microsoft.ReportingServices.Library.DBInterface. GetOneConfigurationI
nfo(Stri
ng key)
| at
|
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetSystemProperty
(String name)
| at
Microsoft.ReportingServices.Library. CachedSystemProperti
es.Get(String
| name)
| at
|
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetParameter(Stri
ng name)
| at Microsoft.ReportingServices.Library.RSService. get_MyReportsEnabled
()
| at Microsoft.ReportingServices.Library.RSService. PathToInternal(Strin
g
| 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(Strin
g
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| Item, String[]& Permissions)
| --- End of inner exception stack trace ---
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| 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. ReportServerNotActiv
atedEx
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. NewStandardSqlComman
d(String
| storedProcedureName)
| at
|
Microsoft.ReportingServices.Library.DBInterface. GetOneConfigurationI
nfo(Stri
ng key)
| at
|
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetSystemProperty
(String name)
| at
Microsoft.ReportingServices.Library. CachedSystemProperti
es.Get(String
| name)
| at
|
Microsoft.ReportingServices.Library. CachedSystemProperti
es.GetParameter(Stri
ng name)
| at Microsoft.ReportingServices.Library.RSService. get_MyReportsEnabled
()
| at Microsoft.ReportingServices.Library.RSService. PathToInternal(Strin
g
| 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(Strin
g
| item, StringCollection& Operations)
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPermissions(Strin
g
| Item, String[]& Permissions)
| --- End of inner exception stack trace ---
| at
|
Microsoft.ReportingServices.WebServer.ReportingService. GetPe | | |