rsactivate issues

After installation of ReportingService (dev edition), I get a note that the
server is not activated. I try to activate via command below and get an
exception about unable to connect to the database. I've attached the log
file as well.
One of the messages said to look for MDAC version, this machine has SQL 2000
SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
else I can do. This is one of several RS installations but none of the
other installations have had this error. Any clue?
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unable to connect to the database (-2147159551)
0x800700
7f --> System.Exception: 0x8007007f
-- 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,
Bas
eCmdLine instance)
Log File______________________
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
System.Exception: 0x8007007f
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 --
w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
System.Exception: 0x8007007f
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 --I am having the exact same error. Any help would be much appreciated.
In case it helps... my server is Windows 2k Server SP4, MDAC 2.8, SQL 2000 SP3
"Sam" wrote:
>
> After installation of ReportingService (dev edition), I get a note that the
> server is not activated. I try to activate via command below and get an
> exception about unable to connect to the database. I've attached the log
> file as well.
> One of the messages said to look for MDAC version, this machine has SQL 2000
> SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
> else I can do. This is one of several RS installations but none of the
> other installations have had this error. Any clue?
>
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
> Failure starting the web service:
> System.Exception: Unable to connect to the database (-2147159551)
> 0x800700
> 7f --> System.Exception: 0x8007007f
> -- 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,
> Bas
> eCmdLine instance)
>
> Log File______________________
>
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
> w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> 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 --
> w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> 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 --
>
>|||I am having the exact same error. Any help would be much appreciated.
In case it helps... my server is Windows 2k Server SP4, MDAC 2.8, SQL 2000
SP3, and Reporting Services SP1
"Sam" wrote:
>
> After installation of ReportingService (dev edition), I get a note that the
> server is not activated. I try to activate via command below and get an
> exception about unable to connect to the database. I've attached the log
> file as well.
> One of the messages said to look for MDAC version, this machine has SQL 2000
> SP3 installed so using cc.exe came up with 2.8 MDAC version. Wondering what
> else I can do. This is one of several RS installations but none of the
> other installations have had this error. Any clue?
>
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsactivate -c "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
> Failure starting the web service:
> System.Exception: Unable to connect to the database (-2147159551)
> 0x800700
> 7f --> System.Exception: 0x8007007f
> -- 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,
> Bas
> eCmdLine instance)
>
> Log File______________________
>
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Exporting public key
> w3wp!crypto!948!10/05/2004-19:23:43:: w WARN: Web Service not activated
> w3wp!crypto!948!10/05/2004-19:23:43:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!948!10/05/2004-19:23:43:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> 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 --
> w3wp!webserver!948!10/05/2004-19:23:43:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159551 -->
> System.Exception: 0x8007007f
> 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 --
>
>sql