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

RS2005 Drop-down list

This there a way to increase the time it takes when users select items from
the drop-down list.
Please note that the drop-down list is setup to extract data items from
backend database (from query). (also, using multi-value selections)When I run the report in Visual Studio, it quick and runs as expected.
However, when the report is deployed and ran, its seems to be slow.
Thanks!
"Terry" wrote:
> This there a way to increase the time it takes when users select items from
> the drop-down list.
> Please note that the drop-down list is setup to extract data items from
> backend database (from query). (also, using multi-value selections)
>|||Hi everybody,
i'm just started using the Reporting services...
I want to display all the staff name in a dropdown list or combo box.
and based on the staff name the report is displayed...
can any one help me..
Thankx in advance
ren
From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Many ways you can do this.
1. Write your own custom code so that depending on the user you can display
reports.
2. If you are storing all your staff name in a table you can query the table
for the dropdown and once it is selected, the name is passed to a stored
procedure and the stored procedure runs the query depending on the staff.
e.g. some staff should not see somethings etc...
Let me know where you store your staff names..
Amarnath, MCTS.
"Renuka" wrote:
> Hi everybody,
> i'm just started using the Reporting services...
> I want to display all the staff name in a dropdown list or combo box.
> and based on the staff name the report is displayed...
> can any one help me..
> Thankx in advance
> renu
> From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>