|
|
You're in the
sql server reporting services
group:RS Activation is failing
sql server reporting services:
After getting the "The report server installation is not initialized." error,
I have tried many suggestions from this newsgroup (registry key permissions, erasing the encryption key from the RS config file, etc... Nothing has helped, I'm still getting the error. The log file is as follows. One error that looks significant to me is "Client is not a local admin. Not attempting activation." I'll be grateful for any help, and for any insight as to which "client" the error message is referring to. <Header> <Product>Microsoft SQL Server Reporting Services, Version 8.00.878.00</Product> <Locale>de-DE</Locale> <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__05_03_2005_20_36_09.log</Path> <SystemName>XXXTEST</SystemName> <OSName>Microsoft Windows NT 5.2.3790.0</OSName> <OSVersion>5.2.3790.0</OSVersion> </Header> w3wp!webserver!b98!03.05.2005-20:36:09:: i INFO: Reporting Web Server started w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!b98!03.05.2005-20:36:09:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. w3wp!resourceutilities!b98!03.05.2005-20:36:09:: i INFO: Running on 0 physical processors, 1 logical processors w3wp!resourceutilities!b98!03.05.2005-20:36:09:: i INFO: Reporting Services starting SKU: Enterprise w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Database Cleanup (Web Service) timer enabled: Cycle: 600 seconds w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds w3wp!runningjobs!b98!03.05.2005-20:36:09:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Initializing crypto as user: NT-AUTORITÄT\NETZWERKDIENST w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Exporting public key w3wp!crypto!474!03.05.2005-20:37:09:: w WARN: Web Service not activated w3wp!crypto!474!03.05.2005-20:37:09:: i INFO: Client is not a local admin. Not attempting activation. w3wp!library!474!03.05.2005-20:37:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException: Die Installation des Berichtsservers ist nicht initialisiert. Weitere Informationen finden Sie in der Dokumentation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException: Die Installation des Berichtsservers ist nicht initialisiert. Weitere Informationen finden Sie in der Dokumentation. w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Initializing crypto as user: NT-AUTORITÄT\NETZWERKDIENST w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Exporting public key w3wp!crypto!b98!03.05.2005-20:38:09:: w WARN: Web Service not activated w3wp!crypto!b98!03.05.2005-20:38:09:: i INFO: Client is not a local admin. Not attempting activation. w3wp!library!b98!03.05.2005-20:38:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException: Die Installation des Berichtsservers ist nicht initialisiert. Weitere Informationen finden Sie in der Dokumentation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException: Die Installation des Berichtsservers ist nicht initialisiert. Weitere Informationen finden Sie in der Dokumentation.
I forgot to mention:
Hello,
To understand the issue better, I'd like to know the following informaiton: 1. When you tried to run the following command, what is the result? RSACTIVATE -C "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" (make sure the path is the one you installed Reporting Services) 2. Did you log on as a local admin and try to access http://localhost/reportserver link? this error happens if the logged in user account which is used to run the Rsactivate did not have permission on the database and database objects in sql server, specifically the reportserver and reportservertempdb. I suggest that you add the user account which is used to run the rsactivate to the sql server box as a local admin. By default local admin has full privileges on the database and the database objects. If you cannot add them as local admin, you can add them just to the reportserver and reportservertempdb. Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVQFpoaVsyfZVL4RFuXyA0cnTIbaQ== | X-WBNR-Posting-Host: 145.254.231.5 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> | Subject: RE: RS Activation is failing | Date: Tue, 3 May 2005 12:30:45 -0700 | Lines: 2 | Message-ID: <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42650 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | I forgot to mention: | SQL Server 2000 SP3, RS SP1, Win 2003, all in one box. |
Hello,
It seems to be issue caused by that form authentication was not configured properly. Please try to use Windows authentication (default configuration) to make sure it works properly. You could refer to the following information from "Using Forms Authentication in Reporting Services" link. Removing the Sample Extension While not generally recommended, it is possible to revert back to Windows Authentication after you have tried out the sample. To revert to Windows security, do the following: Restore the following files from your backup copies: Web.config, RSReportServer.config, and RSWebApplication.config. This should set the authentication and authorization methods for the report server to the default Windows security. This should also remove any entries you made for your extension in the Report Server or Report Manager configuration files. Disable anonymous access in Internet Information Services (IIS) for the report server virtual directory. If it works at this time, you may try to configure form authenctication again to troubleshoot the original issue. Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ== | X-WBNR-Posting-Host: 84.147.135.4 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> | Subject: RE: RS Activation is failing | Date: Wed, 4 May 2005 00:08:03 -0700 | Lines: 23 | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42689 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | 1. I get a successful message when I run the suggested RSACTIVATE command | 2. When I access http://localhost/reportserver, I get a page with a title of | "Reporting Services Error", and the text is "The report server installation | is not initialized. Check the documentation for more information. | (rsReportServerNotActivated) Get Online Help" | 3. I am looged in as local admin, and the administrators group has SA | privileges on the SQL Server. | 4. I have now added the NetworkService account to the local admin group, as | this is the account appearing in the log file (NetzwerkDienst stands for | NetworkService), I have stopped and restarted the ReportServer service, and | tried the RSACTIVATE again. | | I'm still having the problem. | | Also, this a fresh install on Win2003, using Forms Auth as per the Microsoft | article "Using Forms Authentication in Reporting Services.htm". | This setup is working on our current Win 2000 server English, and I'm trying | to upgrade the solution to Win 2003 German. Both RS installations are SP1. | | I have been backing up the RS databases from the win2000 server and | restoring them on the win2003, I also copied the encryption key across using | rskeymgmt. | |
1. I get a successful message when I run the suggested RSACTIVATE command
2. When I access http://localhost/reportserver, I get a page with a title of "Reporting Services Error", and the text is "The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated) Get Online Help" 3. I am looged in as local admin, and the administrators group has SA privileges on the SQL Server. 4. I have now added the NetworkService account to the local admin group, as this is the account appearing in the log file (NetzwerkDienst stands for NetworkService), I have stopped and restarted the ReportServer service, and tried the RSACTIVATE again. I'm still having the problem. Also, this a fresh install on Win2003, using Forms Auth as per the Microsoft article "Using Forms Authentication in Reporting Services.htm". This setup is working on our current Win 2000 server English, and I'm trying to upgrade the solution to Win 2003 German. Both RS installations are SP1. I have been backing up the RS databases from the win2000 server and restoring them on the win2003, I also copied the encryption key across using rskeymgmt.
I have restored the files as per your post, removed anonymous security for
the ReportServer and the Reports virtual directories, then restarted IIS and the ReportServer service. When I navigate to http://localhost/Reports/ I still experience the same problem, and I now get a slightly different error message, with an error number at the end of the message: The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated) Get Online Help -2147159550 [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > It seems to be issue caused by that form authentication was not configured > properly. Please try to use Windows authentication (default configuration) > to make sure it works properly. You could refer to the following > information from "Using Forms Authentication in Reporting Services" link. > > Removing the Sample Extension > While not generally recommended, it is possible to revert back to Windows > Authentication after you have tried out the sample. To revert to Windows > security, do the following: > > Restore the following files from your backup copies: Web.config, > RSReportServer.config, and RSWebApplication.config. This should set the > authentication and authorization methods for the report server to the > default Windows security. This should also remove any entries you made for > your extension in the Report Server or Report Manager configuration files. > > Disable anonymous access in Internet Information Services (IIS) for the > report server virtual directory. > > If it works at this time, you may try to configure form authenctication > again to troubleshoot the original issue. > > Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > -------------------- > | Thread-Topic: RS Activation is failing > | thread-index: AcVQeAOPobWAMXOUQ8iHHiHYJ2+4CQ== > | X-WBNR-Posting-Host: 84.147.135.4 > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> > | Subject: RE: RS Activation is failing > | Date: Wed, 4 May 2005 00:08:03 -0700 > | Lines: 23 > | Message-ID: <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> > | MIME-Version: 1.0 > | Content-Type: text/plain; > | charset="Utf-8" > | Content-Transfer-Encoding: 7bit > | X-Newsreader: Microsoft CDO for Windows 2000 > | Content-Class: urn:content-classes:message > | Importance: normal > | Priority: normal > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 > | Newsgroups: microsoft.public.sqlserver.reportingsvcs > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42689 > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > | > | 1. I get a successful message when I run the suggested RSACTIVATE command > | 2. When I access http://localhost/reportserver, I get a page with a title > of > | "Reporting Services Error", and the text is "The report server > installation > | is not initialized. Check the documentation for more information. > | (rsReportServerNotActivated) Get Online Help" > | 3. I am looged in as local admin, and the administrators group has SA > | privileges on the SQL Server. > | 4. I have now added the NetworkService account to the local admin group, > as > | this is the account appearing in the log file (NetzwerkDienst stands for > | NetworkService), I have stopped and restarted the ReportServer service, > and > | tried the RSACTIVATE again. > | > | I'm still having the problem. > | > | Also, this a fresh install on Win2003, using Forms Auth as per the > Microsoft > | article "Using Forms Authentication in Reporting Services.htm". > | This setup is working on our current Win 2000 server English, and I'm > trying > | to upgrade the solution to Win 2003 German. Both RS installations are SP1. > | > | I have been backing up the RS databases from the win2000 server and > | restoring them on the win2003, I also copied the encryption key across > using > | rskeymgmt. > | > | >
After looking for this error number on the Web, I found out that it relates
to the encryption keys. I restored a fresh backup from the win2000 server, and copied the encryption keys across using rskeymgmt. I can now get to the "Home" page of the RS Manager at URL http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as soon as I click on a folder, I get "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object." The corresponding log file contents are: <Header> <Product>Microsoft SQL Server Reporting Services, Version 8.00.878.00</Product> <Locale>de-DE</Locale> <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__05_05_2005_11_30_56.log</Path> <SystemName>TEST</SystemName> <OSName>Microsoft Windows NT 5.2.3790.0</OSName> <OSVersion>5.2.3790.0</OSVersion> </Header> w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. w3wp!ui!cd4!5/5/2005-11:31:33:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.Security.GetPermissions(String itemName, ItemType catItemType, Byte[] secDesc, StringCollection& operCollection) at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations) at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) w3wp!ui!cd4!5/5/2005-11:31:33:: e ERROR: HTTP status code --> 200 -------Details-------- System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPolicy(Byte[] secDescBlobStored, Hashtable& secDescHash) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.Security.GetPermissions(String itemName, ItemType catItemType, Byte[] secDesc, StringCollection& operCollection) at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations) at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e)
Hello,
It seems the issue is caused by some settings in web.config file. I have included a web.config file on my test machine for your reference. Please backup the original file on your server, replace with the file attached, and then run iisreset to restart IIS services to test. It is under %programfiles%\Microsoft SQL server\mssql\report services\reportServer If the issue persists, please double check the rssvrpolicy.config file to make sure it was not modified properly. Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw== | X-WBNR-Posting-Host: 84.147.136.116 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> | Subject: RE: RS Activation is failing | Date: Thu, 5 May 2005 03:03:09 -0700 | Lines: 274 | Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 8bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42831 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | After looking for this error number on the Web, I found out that it relates | to the encryption keys. I restored a fresh backup from the win2000 server, | and copied the encryption keys across using rskeymgmt. | | I can now get to the "Home" page of the RS Manager at URL | http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as soon as | I click on a folder, I get "An internal error occurred on the report server. | See the error log for more details. (rsInternalError) Get Online Help Object | reference not set to an instance of an object." | | The corresponding log file contents are: | | <Header> | <Product>Microsoft SQL Server Reporting Services, Version | 8.00.878.00</Product> | <Locale>de-DE</Locale> | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting | Services\LogFiles\ReportServerWebApp__05_05_2005_11_30_56.log</Path> | <SystemName>TEST</SystemName> | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> | <OSVersion>5.2.3790.0</OSVersion> | </Header> | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing MaxScheduleWait | to default value of '1' second(s) because it was not specified in | Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | DatabaseQueryTimeout to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName to | default value of 'MSSQLSERVER.1' because it was not specified in | Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | ProcessRecycleOptions to default value of '0' because it was not specified | in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | RunningRequestsScavengerCycle to default value of '30' second(s) because it | was not specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | RunningRequestsDbCycle to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | RunningRequestsAge to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | CleanupCycleMinutes to default value of '10' minute(s) because it was not | specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | SecureConnectionLevel to default value of '1' because it was not specified | in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing DisplayErrorLink | to 'True' as specified in Configuration file. | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | WebServiceUseFileShareStorage to default value of 'False' because it was not | specified in Configuration file. | w3wp!ui!cd4!5/5/2005-11:31:33:: e ERROR: | System.Web.Services.Protocols.SoapException: An internal error occurred on | the report server. See the error log for more details. ---> | Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: | An internal error occurred on the report server. See the error log for more | details. ---> System.NullReferenceException: Object reference not set to an | instance of an object. | at | Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo licy(Byte[] secDescBlobStored, Hashtable& secDescHash) | at | Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc) | at Microsoft.ReportingServices.Library.Security.GetPermissions(String | itemName, ItemType catItemType, Byte[] secDesc, StringCollection& | operCollection) | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String | item, StringCollection& Operations) | --- End of inner exception stack trace --- | at Microsoft.ReportingServices.Library.RSService.GetPermissions(String | item, StringCollection& Operations) | at | Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String | Item, String[]& Permissions) | --- End of inner exception stack trace --- | at | Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String | Item, String[]& Permissions) | w3wp!ui!cd4!5/5/2005-11:31:33:: e ERROR: HTTP status code --> 200 | -------Details--------
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. [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > It seems the issue is caused by some settings in web.config file. > > I have included a web.config file on my test machine for your reference. > Please backup the original file on your server, replace with the file > attached, and then run iisreset to restart IIS services to test. It is > under %programfiles%\Microsoft SQL server\mssql\report services\reportServer > > If the issue persists, please double check the rssvrpolicy.config file to > make sure it was not modified properly. > > Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > -------------------- > | Thread-Topic: RS Activation is failing > | thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw== > | X-WBNR-Posting-Host: 84.147.136.116 > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> > | Subject: RE: RS Activation is failing > | Date: Thu, 5 May 2005 03:03:09 -0700 > | Lines: 274 > | Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> > | MIME-Version: 1.0 > | Content-Type: text/plain; > | charset="Utf-8" > | Content-Transfer-Encoding: 8bit > | X-Newsreader: Microsoft CDO for Windows 2000 > | Content-Class: urn:content-classes:message > | Importance: normal > | Priority: normal > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 > | Newsgroups: microsoft.public.sqlserver.reportingsvcs > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42831 > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > | > | After looking for this error number on the Web, I found out that it > relates > | to the encryption keys. I restored a fresh backup from the win2000 > server, > | and copied the encryption keys across using rskeymgmt. > | > | I can now get to the "Home" page of the RS Manager at URL > | http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as > soon as > | I click on a folder, I get "An internal error occurred on the report > server. > | See the error log for more details. (rsInternalError) Get Online Help > Object > | reference not set to an instance of an object." > | > | The corresponding log file contents are: > | > | <Header> > | <Product>Microsoft SQL Server Reporting Services, Version > | 8.00.878.00</Product> > | <Locale>de-DE</Locale> > | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> > | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting > | Services\LogFiles\ReportServerWebApp__05_05_2005_11_30_56.log</Path> > | <SystemName>TEST</SystemName> > | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> > | <OSVersion>5.2.3790.0</OSVersion> > | </Header> > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration > file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > MaxScheduleWait > | to default value of '1' second(s) because it was not specified in > | Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | DatabaseQueryTimeout to default value of '30' second(s) because it was > not > | specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName > to > | default value of 'MSSQLSERVER.1' because it was not specified in > | Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | ProcessRecycleOptions to default value of '0' because it was not > specified > | in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | RunningRequestsScavengerCycle to default value of '30' second(s) because > it > | was not specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | RunningRequestsDbCycle to default value of '30' second(s) because it was > not > | specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | RunningRequestsAge to default value of '30' second(s) because it was not > | specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | CleanupCycleMinutes to default value of '10' minute(s) because it was not > | specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | SecureConnectionLevel to default value of '1' because it was not > specified > | in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > DisplayErrorLink > | to 'True' as specified in Configuration file. > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing > | WebServiceUseFileShareStorage to default value of 'False' because it was > not > | specified in Configuration file. > | w3wp!ui!cd4!5/5/2005-11:31:33:: e ERROR: > | System.Web.Services.Protocols.SoapException: An internal error occurred > on > | the report server. See the error log for more details. ---> > | > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: > | An internal error occurred on the report server. See the error log for > more > | details. ---> System.NullReferenceException: Object reference not set to > an > | instance of an object. > | at > | > Microsoft.ReportingServices.Authorization.SdAndType.PrepareToRestoreBinaryPo > licy(Byte[] secDescBlobStored, Hashtable& secDescHash) > | at > | > Microsoft.ReportingServices.Authorization.WindowsAuthorization.GetPermission > s(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] > secDesc) > | at Microsoft.ReportingServices.Library.Security.GetPermissions(String > | itemName, ItemType catItemType, Byte[] secDesc, StringCollection&
Hello,
I agree with you sometimes reinstall might be more effiicient method to solve this type of issues. :-) Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVSHO0o6V3TQIGmTd2mU1ktlKH1tQ== | X-WBNR-Posting-Host: 84.147.137.47 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> | Subject: RE: RS Activation is failing | Date: Fri, 6 May 2005 02:21:04 -0700 | Lines: 421 | Message-ID: <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 8bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42970 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | I have restored the rssvrpolicy.config in both directories (ReportServer and | ReportManager) and I have the same problem. I didn't find the web.config file | from your server that you are mentionning (I don't know where to look for it). | | I'm going to completely reinstall Reporting Services, and I'll also try to | get hotfix 821334 as it looks like it may be relevant. | | thanks anyway. | [quoted text, click to view] | "Peter Yang [MSFT]" wrote: | | > Hello, | > | > It seems the issue is caused by some settings in web.config file. | > | > I have included a web.config file on my test machine for your reference. | > Please backup the original file on your server, replace with the file | > attached, and then run iisreset to restart IIS services to test. It is | > under %programfiles%\Microsoft SQL server\mssql\report services\reportServer | > | > If the issue persists, please double check the rssvrpolicy.config file to | > make sure it was not modified properly. | > | > Regards, | > | > Peter Yang | > MCSE2000/2003, MCSA, MCDBA | > Microsoft Online Partner Support | > | > When responding to posts, please "Reply to Group" via your newsreader so | > that others may learn and benefit from your issue. | > | > ===================================================== | > | > This posting is provided "AS IS" with no warranties, and confers no rights. | > | > | > | > | > -------------------- | > | Thread-Topic: RS Activation is failing | > | thread-index: AcVRWaOuBQFMWf7jRZauSM4LB2CPuw== | > | X-WBNR-Posting-Host: 84.147.136.116 | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> | > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> | > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> | > | Subject: RE: RS Activation is failing | > | Date: Thu, 5 May 2005 03:03:09 -0700 | > | Lines: 274 | > | Message-ID: <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> | > | MIME-Version: 1.0 | > | Content-Type: text/plain; | > | charset="Utf-8" | > | Content-Transfer-Encoding: 8bit | > | X-Newsreader: Microsoft CDO for Windows 2000 | > | Content-Class: urn:content-classes:message | > | Importance: normal | > | Priority: normal | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42831 | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | > | | > | After looking for this error number on the Web, I found out that it | > relates | > | to the encryption keys. I restored a fresh backup from the win2000 | > server, | > | and copied the encryption keys across using rskeymgmt. | > | | > | I can now get to the "Home" page of the RS Manager at URL | > | http://localhost/Reports/Pages/Folder.aspx?IsDetailsView=True, but as | > soon as | > | I click on a folder, I get "An internal error occurred on the report | > server. | > | See the error log for more details. (rsInternalError) Get Online Help | > Object | > | reference not set to an instance of an object." | > | | > | The corresponding log file contents are: | > | | > | <Header> | > | <Product>Microsoft SQL Server Reporting Services, Version | > | 8.00.878.00</Product> | > | <Locale>de-DE</Locale> | > | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> | > | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting | > | Services\LogFiles\ReportServerWebApp__05_05_2005_11_30_56.log</Path> | > | <SystemName>TEST</SystemName> | > | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> | > | <OSVersion>5.2.3790.0</OSVersion> | > | </Header> | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | > | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration | > file. | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | > MaxScheduleWait | > | to default value of '1' second(s) because it was not specified in | > | Configuration file. | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | > | DatabaseQueryTimeout to default value of '30' second(s) because it was | > not | > | specified in Configuration file. | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing InstanceName | > to | > | default value of 'MSSQLSERVER.1' because it was not specified in | > | Configuration file. | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing | > | ProcessRecycleOptions to default value of '0' because it was not | > specified | > | in Configuration file. | > | w3wp!library!cb0!05.05.2005-11:30:56:: i INFO: Initializing
I'm still having the same problem.
I de-installed Reporting Services, and reinstalled, applied SP1. The RS server was functionnal. I applied the Forms Authentication changes as per the Microsoft article. The RS server was functionnal. I restored the ReportServer and ReportServerTempDB from the Win2000 server and copied the encryption key using rskeymgmt. I'm still getting the same error: The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated) I ran rsactivate as per your first post, and I'm still getting the error. All possible users have been given SA priviledges on the SQL Server (ASPNET, IUSR_xxx, the account used by RS to connect to SQL, the local admin and the administrators group) Could it be because: 1) You cannot restore a RS server from a Win2000 English machine to a Win2003 German machine? 2) You cannot restore a RS Server to a server that has a different name? Here is the log: <Header> <Product>Microsoft SQL Server Reporting Services, Version 8.00.878.00</Product> <Locale>de-DE</Locale> <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path> <SystemName>HERAS10TEST</SystemName> <OSName>Microsoft Windows NT 5.2.3790.0</OSName> <OSVersion>5.2.3790.0</OSVersion> </Header> w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: Unable to communicate with report server. Please verify that the report server is operational. w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: HTTP status code --> 500 -------Details-------- CantCommunicateWithReportServerException: Unable to communicate with report server. Please verify that the report server is operational. at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level) at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain() w3wp!ui!ac!5/9/2005-14:33:19:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) w3wp!ui!ac!5/9/2005-14:33:38:: e ERROR: System.Web.Services.Protocols.SoapException: The report server installation is not initialized. Check the documentation for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException: The report server installation is not initialized. Check the documentation for more information. at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection() at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection() at Microsoft.ReportingServices.Library.Storage.get_Connection() at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName) at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key) at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name) at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name) at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name) at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled() at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source) at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate) at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path) at
Hello,
I thought you have followed the following KB to move database between servers. 842425 How to move a Reporting Services database from a computer that is http://support.microsoft.com/?id=842425 If it is the case, the issue might be related to Windows 2000 uses ASP.net account while Windows 2003 uses Network Service account in Application pool. You may want to add Network service account with proper permssion to reportserver databases to see if it helps. Also, I 'm not quite sure if German OS shall bring issues. You may want to call local CSS to confirm this but I personally don't think it shall be a issue. You may compare collation settings between databases on different servers. Different computer name shall not be a problem here. Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg== | X-WBNR-Posting-Host: 84.147.167.79 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> | Subject: RE: RS Activation is failing | Date: Mon, 9 May 2005 05:40:05 -0700 | Lines: 246 | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 8bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43161 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | I'm still having the same problem. | I de-installed Reporting Services, and reinstalled, applied SP1. | The RS server was functionnal. | | I applied the Forms Authentication changes as per the Microsoft article. | The RS server was functionnal. | | I restored the ReportServer and ReportServerTempDB from the Win2000 server | and copied the encryption key using rskeymgmt. | I'm still getting the same error: | The report server installation is not initialized. Check the documentation | for more information. (rsReportServerNotActivated) | | I ran rsactivate as per your first post, and I'm still getting the error. | | All possible users have been given SA priviledges on the SQL Server (ASPNET, | IUSR_xxx, the account used by RS to connect to SQL, the local admin and the | administrators group) | | Could it be because: | 1) You cannot restore a RS server from a Win2000 English machine to a | Win2003 German machine? | 2) You cannot restore a RS Server to a server that has a different name? | | Here is the log: | | <Header> | <Product>Microsoft SQL Server Reporting Services, Version | 8.00.878.00</Product> | <Locale>de-DE</Locale> | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting | Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path> | <SystemName>HERAS10TEST</SystemName> | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> | <OSVersion>5.2.3790.0</OSVersion> | </Header> | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing MaxScheduleWait | to default value of '1' second(s) because it was not specified in | Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | DatabaseQueryTimeout to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing InstanceName to | default value of 'MSSQLSERVER.1' because it was not specified in | Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | ProcessRecycleOptions to default value of '0' because it was not specified | in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | RunningRequestsScavengerCycle to default value of '30' second(s) because it | was not specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | RunningRequestsDbCycle to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | RunningRequestsAge to default value of '30' second(s) because it was not | specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | CleanupCycleMinutes to default value of '10' minute(s) because it was not | specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | SecureConnectionLevel to default value of '1' because it was not specified | in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing DisplayErrorLink | to 'True' as specified in Configuration file. | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | WebServiceUseFileShareStorage to default value of 'False' because it was not | specified in Configuration file. | w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: Unable to communicate with report | server. Please verify that the report server is operational. | w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: HTTP status code --> 500 | -------Details-------- | CantCommunicateWithReportServerException: Unable to communicate with report | server. Please verify that the report server is operational. | | at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() | | at | Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String | methodname) | | at Microsoft.ReportingServices.UI.Global.SecureAllAPI() | | at | Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
Hello,
If you have any update, you may want to post back in the newsgroup. I am sure it shall benefit the community. Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA== | X-WBNR-Posting-Host: 84.56.12.223 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> <2ni8NYTVFHA.3928@TK2MSFTNGXA01.phx.gbl> | Subject: RE: RS Activation is failing | Date: Wed, 11 May 2005 04:00:01 -0700 | Lines: 394 | Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 8bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43405 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | OK. I just opened a support case with MS Germany. | [quoted text, click to view] | "Peter Yang [MSFT]" wrote: | | > Hello, | > | > I thought you have followed the following KB to move database between | > servers. | > | > 842425 How to move a Reporting Services database from a computer that is | > http://support.microsoft.com/?id=842425 | > | > If it is the case, the issue might be related to Windows 2000 uses ASP.net | > account while Windows 2003 uses Network Service account in Application | > pool. You may want to add Network service account with proper permssion to | > reportserver databases to see if it helps. | > | > Also, I 'm not quite sure if German OS shall bring issues. You may want to | > call local CSS to confirm this but I personally don't think it shall be a | > issue. You may compare collation settings between databases on different | > servers. | > | > Different computer name shall not be a problem here. | > | > Regards, | > | > Peter Yang | > MCSE2000/2003, MCSA, MCDBA | > Microsoft Online Partner Support | > | > When responding to posts, please "Reply to Group" via your newsreader so | > that others may learn and benefit from your issue. | > | > ===================================================== | > | > | > This posting is provided "AS IS" with no warranties, and confers no rights. | > | > | > | > | > -------------------- | > | Thread-Topic: RS Activation is failing | > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg== | > | X-WBNR-Posting-Host: 84.147.167.79 | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> | > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> | > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> | > <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> | > <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> | > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> | > <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> | > | Subject: RE: RS Activation is failing | > | Date: Mon, 9 May 2005 05:40:05 -0700 | > | Lines: 246 | > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> | > | MIME-Version: 1.0 | > | Content-Type: text/plain; | > | charset="Utf-8" | > | Content-Transfer-Encoding: 8bit | > | X-Newsreader: Microsoft CDO for Windows 2000 | > | Content-Class: urn:content-classes:message | > | Importance: normal | > | Priority: normal | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43161 | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | > | | > | I'm still having the same problem. | > | I de-installed Reporting Services, and reinstalled, applied SP1. | > | The RS server was functionnal. | > | | > | I applied the Forms Authentication changes as per the Microsoft article. | > | The RS server was functionnal. | > | | > | I restored the ReportServer and ReportServerTempDB from the Win2000 | > server | > | and copied the encryption key using rskeymgmt. | > | I'm still getting the same error: | > | The report server installation is not initialized. Check the | > documentation | > | for more information. (rsReportServerNotActivated) | > | | > | I ran rsactivate as per your first post, and I'm still getting the error. | > | | > | All possible users have been given SA priviledges on the SQL Server | > (ASPNET, | > | IUSR_xxx, the account used by RS to connect to SQL, the local admin and | > the | > | administrators group) | > | | > | Could it be because: | > | 1) You cannot restore a RS server from a Win2000 English machine to a | > | Win2003 German machine? | > | 2) You cannot restore a RS Server to a server that has a different name? | > | | > | Here is the log: | > | | > | <Header> | > | <Product>Microsoft SQL Server Reporting Services, Version | > | 8.00.878.00</Product> | > | <Locale>de-DE</Locale> | > | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> | > | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting | > | Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path> | > | <SystemName>HERAS10TEST</SystemName> | > | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> | > | <OSVersion>5.2.3790.0</OSVersion> | > | </Header> | > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing | > | MaxActiveReqForOneUser to '20' requests(s) as specified in
OK. I just opened a support case with MS Germany.
[quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > I thought you have followed the following KB to move database between > servers. > > 842425 How to move a Reporting Services database from a computer that is > http://support.microsoft.com/?id=842425 > > If it is the case, the issue might be related to Windows 2000 uses ASP.net > account while Windows 2003 uses Network Service account in Application > pool. You may want to add Network service account with proper permssion to > reportserver databases to see if it helps. > > Also, I 'm not quite sure if German OS shall bring issues. You may want to > call local CSS to confirm this but I personally don't think it shall be a > issue. You may compare collation settings between databases on different > servers. > > Different computer name shall not be a problem here. > > Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > -------------------- > | Thread-Topic: RS Activation is failing > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg== > | X-WBNR-Posting-Host: 84.147.167.79 > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> > <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> > <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> > <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> > | Subject: RE: RS Activation is failing > | Date: Mon, 9 May 2005 05:40:05 -0700 > | Lines: 246 > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> > | MIME-Version: 1.0 > | Content-Type: text/plain; > | charset="Utf-8" > | Content-Transfer-Encoding: 8bit > | X-Newsreader: Microsoft CDO for Windows 2000 > | Content-Class: urn:content-classes:message > | Importance: normal > | Priority: normal > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 > | Newsgroups: microsoft.public.sqlserver.reportingsvcs > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43161 > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > | > | I'm still having the same problem. > | I de-installed Reporting Services, and reinstalled, applied SP1. > | The RS server was functionnal. > | > | I applied the Forms Authentication changes as per the Microsoft article. > | The RS server was functionnal. > | > | I restored the ReportServer and ReportServerTempDB from the Win2000 > server > | and copied the encryption key using rskeymgmt. > | I'm still getting the same error: > | The report server installation is not initialized. Check the > documentation > | for more information. (rsReportServerNotActivated) > | > | I ran rsactivate as per your first post, and I'm still getting the error. > | > | All possible users have been given SA priviledges on the SQL Server > (ASPNET, > | IUSR_xxx, the account used by RS to connect to SQL, the local admin and > the > | administrators group) > | > | Could it be because: > | 1) You cannot restore a RS server from a Win2000 English machine to a > | Win2003 German machine? > | 2) You cannot restore a RS Server to a server that has a different name? > | > | Here is the log: > | > | <Header> > | <Product>Microsoft SQL Server Reporting Services, Version > | 8.00.878.00</Product> > | <Locale>de-DE</Locale> > | <TimeZone>Mitteleuropäische Sommerzeit </TimeZone> > | <Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting > | Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path> > | <SystemName>HERAS10TEST</SystemName> > | <OSName>Microsoft Windows NT 5.2.3790.0</OSName> > | <OSVersion>5.2.3790.0</OSVersion> > | </Header> > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration > file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > MaxScheduleWait > | to default value of '1' second(s) because it was not specified in > | Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | DatabaseQueryTimeout to default value of '30' second(s) because it was > not > | specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing InstanceName > to > | default value of 'MSSQLSERVER.1' because it was not specified in > | Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | ProcessRecycleOptions to default value of '0' because it was not > specified > | in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | RunningRequestsScavengerCycle to default value of '30' second(s) because > it > | was not specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | RunningRequestsDbCycle to default value of '30' second(s) because it was > not > | specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | RunningRequestsAge to default value of '30' second(s) because it was not > | specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | CleanupCycleMinutes to default value of '10' minute(s) because it was not > | specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | SecureConnectionLevel to default value of '1' because it was not > specified > | in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > DisplayErrorLink > | to 'True' as specified in Configuration file. > | w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing > | WebServiceUseFileShareStorage to default value of 'False' because it was > not > | specified in Configuration file. > | w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: Unable to communicate with report > | server. Please verify that the report server is operational. > | w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: HTTP status code --> 500 > | -------Details-------- > | CantCommunicateWithReportServerException: Unable to communicate with > report
I got the solution. One needs to first transfer the 2 databases and restore
them on the new server, copy the encryption key and run rskeymgmt. Then go to the Report manager so that the RS installation gets activated. And then and only then, reapply all changes necessary to implement forms auth. My problem was that I had copied the 6 config files that are involved in forms auth from the old server, and there is encrypted info in there that isn't valid on the new server. Also, activation only works in Windows authentication mode, that's why one has to start in Windows mode, and only then move to Forms Auth. [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > If you have any update, you may want to post back in the newsgroup. I am > sure it shall benefit the community. > > Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > -------------------- > | Thread-Topic: RS Activation is failing > | thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA== > | X-WBNR-Posting-Host: 84.56.12.223 > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> > <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> > <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> > <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> > <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> > <2ni8NYTVFHA.3928@TK2MSFTNGXA01.phx.gbl> > | Subject: RE: RS Activation is failing > | Date: Wed, 11 May 2005 04:00:01 -0700 > | Lines: 394 > | Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@microsoft.com> > | MIME-Version: 1.0 > | Content-Type: text/plain; > | charset="Utf-8" > | Content-Transfer-Encoding: 8bit > | X-Newsreader: Microsoft CDO for Windows 2000 > | Content-Class: urn:content-classes:message > | Importance: normal > | Priority: normal > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 > | Newsgroups: microsoft.public.sqlserver.reportingsvcs > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43405 > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > | > | OK. I just opened a support case with MS Germany. > | > | "Peter Yang [MSFT]" wrote: > | > | > Hello, > | > > | > I thought you have followed the following KB to move database between > | > servers. > | > > | > 842425 How to move a Reporting Services database from a computer that is > | > http://support.microsoft.com/?id=842425 > | > > | > If it is the case, the issue might be related to Windows 2000 uses > ASP.net > | > account while Windows 2003 uses Network Service account in Application > | > pool. You may want to add Network service account with proper permssion > to > | > reportserver databases to see if it helps. > | > > | > Also, I 'm not quite sure if German OS shall bring issues. You may want > to > | > call local CSS to confirm this but I personally don't think it shall be > a > | > issue. You may compare collation settings between databases on > different > | > servers. > | > > | > Different computer name shall not be a problem here. > | > > | > Regards, > | > > | > Peter Yang > | > MCSE2000/2003, MCSA, MCDBA > | > Microsoft Online Partner Support > | > > | > When responding to posts, please "Reply to Group" via your newsreader > so > | > that others may learn and benefit from your issue. > | > > | > ===================================================== > | > > | > > | > This posting is provided "AS IS" with no warranties, and confers no > rights. > | > > | > > | > > | > > | > -------------------- > | > | Thread-Topic: RS Activation is failing > | > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg== > | > | X-WBNR-Posting-Host: 84.147.167.79 > | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> > | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> > | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> > | > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> > | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> > | > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> > | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> > | > <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> > | > <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> > | > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> > | > <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> > | > | Subject: RE: RS Activation is failing > | > | Date: Mon, 9 May 2005 05:40:05 -0700 > | > | Lines: 246 > | > | Message-ID: <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> > | > | MIME-Version: 1.0 > | > | Content-Type: text/plain; > | > | charset="Utf-8" > | > | Content-Transfer-Encoding: 8bit > | > | X-Newsreader: Microsoft CDO for Windows 2000 > | > | Content-Class: urn:content-classes:message > | > | Importance: normal > | > | Priority: normal > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl > | > | Xref: TK2MSFTNGXA01.phx.gbl > microsoft.public.sqlserver.reportingsvcs:43161 > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > | > | > | > | I'm still having the same problem. > | > | I de-installed Reporting Services, and reinstalled, applied SP1. > | > | The RS server was functionnal. > | > | > | > | I applied the Forms Authentication changes as per the Microsoft > article. > | > | The RS server was functionnal. > | > | > | > | I restored the ReportServer and ReportServerTempDB from the Win2000 > | > server > | > | and copied the encryption key using rskeymgmt. > | > | I'm still getting the same error: > | > | The report server installation is not initialized. Check the > | > documentation > | > | for more information. (rsReportServerNotActivated) > | > | > | > | I ran rsactivate as per your first post, and I'm still getting the > error. > | > | > | > | All possible users have been given SA priviledges on the SQL Server > | > (ASPNET,
Great to hear you find the resolution!
Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: RS Activation is failing | thread-index: AcVi0T9SlXafG/0OSkGCjJHxspjndg== | X-WBNR-Posting-Host: 84.147.150.94 | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> <2ni8NYTVFHA.3928@TK2MSFTNGXA01.phx.gbl> <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@microsoft.com> <l#A8gfpVFHA.460@TK2MSFTNGXA01.phx.gbl> | Subject: RE: RS Activation is failing | Date: Fri, 27 May 2005 08:32:10 -0700 | Lines: 313 | Message-ID: <FB215117-2B1A-485E-A705-D35E48D72827@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 8bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:44903 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | I got the solution. One needs to first transfer the 2 databases and restore | them on the new server, copy the encryption key and run rskeymgmt. | Then go to the Report manager so that the RS installation gets activated. | And then and only then, reapply all changes necessary to implement forms auth. | My problem was that I had copied the 6 config files that are involved in | forms auth from the old server, and there is encrypted info in there that | isn't valid on the new server. Also, activation only works in Windows | authentication mode, that's why one has to start in Windows mode, and only | then move to Forms Auth. | | [quoted text, click to view] | "Peter Yang [MSFT]" wrote: | | > Hello, | > | > If you have any update, you may want to post back in the newsgroup. I am | > sure it shall benefit the community. | > | > Regards, | > | > Peter Yang | > MCSE2000/2003, MCSA, MCDBA | > Microsoft Online Partner Support | > | > When responding to posts, please "Reply to Group" via your newsreader so | > that others may learn and benefit from your issue. | > | > ===================================================== | > | > This posting is provided "AS IS" with no warranties, and confers no rights. | > | > | > | > | > -------------------- | > | Thread-Topic: RS Activation is failing | > | thread-index: AcVWGJQytNcZFSd0R3SlpX74uU3LxA== | > | X-WBNR-Posting-Host: 84.56.12.223 | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam> | > | References: <8A324CAC-F186-4ECD-9D1A-5ADEAF6AAF91@microsoft.com> | > <DABDE5FC-2D14-4659-9617-E13FDDDD7688@microsoft.com> | > <EutxrsFUFHA.3052@TK2MSFTNGXA01.phx.gbl> | > <703E5FCD-3BD0-41BF-8394-82ECD304367E@microsoft.com> | > <YChiBASUFHA.2184@TK2MSFTNGXA01.phx.gbl> | > <E21F36EB-AABE-4EE0-9D7E-4D5992026577@microsoft.com> | > <36C317C7-B231-43E9-A5A3-C0325D7822DE@microsoft.com> | > <nPaDQMgUFHA.3336@TK2MSFTNGXA01.phx.gbl> | > <6F989D22-2C10-4616-89D5-1C86B9E2ACDA@microsoft.com> | > <xY$u8RFVFHA.2184@TK2MSFTNGXA01.phx.gbl> | > <38E7E931-AC82-470D-A43B-51C04D563C00@microsoft.com> | > <2ni8NYTVFHA.3928@TK2MSFTNGXA01.phx.gbl> | > | Subject: RE: RS Activation is failing | > | Date: Wed, 11 May 2005 04:00:01 -0700 | > | Lines: 394 | > | Message-ID: <FAC3D018-70FA-45BE-9FB6-3978E62C8BED@microsoft.com> | > | MIME-Version: 1.0 | > | Content-Type: text/plain; | > | charset="Utf-8" | > | Content-Transfer-Encoding: 8bit | > | X-Newsreader: Microsoft CDO for Windows 2000 | > | Content-Class: urn:content-classes:message | > | Importance: normal | > | Priority: normal | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43405 | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | > | | > | OK. I just opened a support case with MS Germany. | > | [quoted text, click to view] | > | "Peter Yang [MSFT]" wrote: | > | | > | > Hello, | > | > | > | > I thought you have followed the following KB to move database between | > | > servers. | > | > | > | > 842425 How to move a Reporting Services database from a computer that is | > | > http://support.microsoft.com/?id=842425 | > | > | > | > If it is the case, the issue might be related to Windows 2000 uses | > ASP.net | > | > account while Windows 2003 uses Network Service account in Application | > | > pool. You may want to add Network service account with proper permssion | > to | > | > reportserver databases to see if it helps. | > | > | > | > Also, I 'm not quite sure if German OS shall bring issues. You may want | > to | > | > call local CSS to confirm this but I personally don't think it shall be | > a | > | > issue. You may compare collation settings between databases on | > different | > | > servers. | > | > | > | > Different computer name shall not be a problem here. | > | > | > | > Regards, | > | > | > | > Peter Yang | > | > MCSE2000/2003, MCSA, MCDBA | > | > Microsoft Online Partner Support | > | > | > | > When responding to posts, please "Reply to Group" via your newsreader | > so | > | > that others may learn and benefit from your issue. | > | > | > | > ===================================================== | > | > | > | > | > | > This posting is provided "AS IS" with no warranties, and confers no | > rights. | > | > | > | > | > | > | > | > | > | > -------------------- | > | > | Thread-Topic: RS Activation is failing | > | > | thread-index: AcVUlDo+04NSR2T6RyaKWWnSC8aHtg== | > | > | X-WBNR-Posting-Host: 84.147.167.79 | > | > | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |