rsactivate returns error, unable to activate error

Failure starting the web service:
Unexpected database error (-2147159548) 0x80004002Hi, possibly your configuration is bad, try runnig, rsconfig.exe with the
new parameters and then try with this again, in most cases this problem is
for bad configuration.
"hcas" wrote:
> Failure starting the web service:
> Unexpected database error (-2147159548) 0x80004002|||Hi, the problem is because the ASPNet is not reg over IIS, with this command
you can repair this.
c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
the aspnet_regiis.exe is a command of .net Framework
Best Regards
John Bocachica
Colombia|||HI John:
I have already tried quite a few different rsconfig.exe settings and users
with no luck. I also re-registered aspnet (I am using a higher version,
1.1.4322) and its dll. The same error occurs when I attempt to use the
rsactivate command. If I use the server name as opposed to the config file,
I get the following error.
Failure initializing remote NT Service:
Unexpected database error (-2147159548) 0x80004002
"John Bocachica" wrote:
> Hi, the problem is because the ASPNet is not reg over IIS, with this command
> you can repair this.
> c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
> regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
> the aspnet_regiis.exe is a command of .net Framework
> Best Regards
> John Bocachica
> Colombia

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