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.
Showing posts with label folks. Show all posts
Showing posts with label folks. Show all posts
Subscribe to:
Posts (Atom)