Hi folks!
After the installation of Reporting Services i received the following error:
The report server installation is not initialized.
First i just continued with the installation of the Service Packs and after
that I tried to activate it with rsactivate, but this didn't work because of
an other error.
rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t
Result:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
--> System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
System:
Win2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
I'd appreciate help from Microsoft staff on this topic!
I did everything that came to my mind to fix this:
- reg_iis -i
- MDAC reinstalled
- rskeymgmt -d:
--> Result: Unexpected database error (-2147159548) 0x80040154
- deletet encryption keys manually (in the ReportServer database)
ReportServerLog:
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Exporting public key
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Client is a local admin.
Activating web service via RPC.
aspnet_wp!library!c2c!11/23/2005-10:11:06:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
aspnet_wp!webserver!c2c!11/23/2005-10:11:08:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Exporting public key
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Client is not a local
admin. Not attempting activation.
This user is a local admin, so why do I get these errors?
What can i do to activate Reporting Services? Are there some things a can
change manually in the database?
Thx for any help
YaraIt was the MDAC.
The automatic installation of MDAC failed all the time without
prompting an error message, that's why I didn't notice it.
I had to manually check every dll and overwrite older versions. Then
reregister it.
Hope this will help other users.
No comments:
Post a Comment