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

rsactivate error message

Hello all,

Since I installed SQL Server 2005 on the same server than SQL 2000, my Reporting Service is getting me this error:

"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help

Bad Data. (Exception from HRESULT: 0x80090005)"

I looked over some other logs and forums, and pretty much all pointed to use the rsactivate utility. Well, I am getting frustrated trying to run the rsactivate utility since I typed in the command rsactivate -r and got an error message that didn't expect to get.

Ej:

C:\>rsactivate -r
Either the WMI provider or the path to the local config file must be specified

Then I typed in the path and still got this:

C:\>rsactivate -r "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
Either the WMI provider or the path to the local config file must be specified

Does someone out there have had this situation or escenario before and what you did to solve it?....

I really need an input or hint on this, so I will appreciate any help.

Thanks in advance.

AJ

Hi I think your using the wrong command... To reactivate you must use the -c option, try this command reactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

rsactivate error message

Hello all,

Since I installed SQL Server 2005 on the same server than SQL 2000, my Reporting Service is getting me this error:

"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help

Bad Data. (Exception from HRESULT: 0x80090005)"

I looked over some other logs and forums, and pretty much all pointed to use the rsactivate utility. Well, I am getting frustrated trying to run the rsactivate utility since I typed in the command rsactivate -r and got an error message that didn't expect to get.

Ej:

C:\>rsactivate -r
Either the WMI provider or the path to the local config file must be specified

Then I typed in the path and still got this:

C:\>rsactivate -r "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
Either the WMI provider or the path to the local config file must be specified

Does someone out there have had this situation or escenario before and what you did to solve it?....

I really need an input or hint on this, so I will appreciate any help.

Thanks in advance.

AJ

Hi I think your using the wrong command... To reactivate you must use the -c option, try this command reactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

rsactivate error - trying to install on 2003 with Sharepoint servi

I am trying to install SQL Reporting Services on a Windows Server 2003 box
that is running Sharepoint Services 2.0.
When you run the install you are warned that you will need to manually
initialize SQL Reporting because of Sharepoint and are referred to the
documentation. In the rssetup.chm there is an article entitled
"Troubleshooting a Side-by-Side Installation of Reporting Services and
Windows SharePoint Services". I followed these instructions, but when I get
to the last step where you run rsactivate, I get an error:
Failure starting the web service:
The service is already activated.
I did have reporting installed on this server once before but it was
uninstalled. I tried uninstalling reporting services when I got this error,
then tried again but I get the same result. I've been deleting the virtual
directories, the program files folder, and the databases before trying again.
I also noticed that two com + packages are left behind. If you don't remove
them the next installation adds two more. I removed all of them and tried
again but still the same result. I don't possess any knowledge of web
services so I'm not sure where to look next.
Can anyone help please?
--
-JeffWhat error message do you see when viewing http://localhost/reportserver?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> I am trying to install SQL Reporting Services on a Windows Server 2003 box
> that is running Sharepoint Services 2.0.
> When you run the install you are warned that you will need to manually
> initialize SQL Reporting because of Sharepoint and are referred to the
> documentation. In the rssetup.chm there is an article entitled
> "Troubleshooting a Side-by-Side Installation of Reporting Services and
> Windows SharePoint Services". I followed these instructions, but when I
get
> to the last step where you run rsactivate, I get an error:
> Failure starting the web service:
> The service is already activated.
> I did have reporting installed on this server once before but it was
> uninstalled. I tried uninstalling reporting services when I got this
error,
> then tried again but I get the same result. I've been deleting the
virtual
> directories, the program files folder, and the databases before trying
again.
> I also noticed that two com + packages are left behind. If you don't
remove
> them the next installation adds two more. I removed all of them and tried
> again but still the same result. I don't possess any knowledge of web
> services so I'm not sure where to look next.
> Can anyone help please?
> --
> -Jeff|||Reporting Services Erro
----
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.
----
Microsoft Reporting Services
"Brian Hartman [MSFT]" wrote:
> What error message do you see when viewing http://localhost/reportserver?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > I am trying to install SQL Reporting Services on a Windows Server 2003 box
> > that is running Sharepoint Services 2.0.
> >
> > When you run the install you are warned that you will need to manually
> > initialize SQL Reporting because of Sharepoint and are referred to the
> > documentation. In the rssetup.chm there is an article entitled
> > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > Windows SharePoint Services". I followed these instructions, but when I
> get
> > to the last step where you run rsactivate, I get an error:
> >
> > Failure starting the web service:
> > The service is already activated.
> >
> > I did have reporting installed on this server once before but it was
> > uninstalled. I tried uninstalling reporting services when I got this
> error,
> > then tried again but I get the same result. I've been deleting the
> virtual
> > directories, the program files folder, and the databases before trying
> again.
> > I also noticed that two com + packages are left behind. If you don't
> remove
> > them the next installation adds two more. I removed all of them and tried
> > again but still the same result. I don't possess any knowledge of web
> > services so I'm not sure where to look next.
> >
> > Can anyone help please?
> >
> > --
> > -Jeff
>
>|||Try the following: rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> Reporting Services Error
> ----
--
> The report server cannot decrypt the symmetric key used to access
sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. (rsReportServerDisabled) Get
> Online Help
> Bad Data.
> ----
--
> Microsoft Reporting Services
>
>
> "Brian Hartman [MSFT]" wrote:
> > What error message do you see when viewing
http://localhost/reportserver?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > I am trying to install SQL Reporting Services on a Windows Server 2003
box
> > > that is running Sharepoint Services 2.0.
> > >
> > > When you run the install you are warned that you will need to manually
> > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > documentation. In the rssetup.chm there is an article entitled
> > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > Windows SharePoint Services". I followed these instructions, but when
I
> > get
> > > to the last step where you run rsactivate, I get an error:
> > >
> > > Failure starting the web service:
> > > The service is already activated.
> > >
> > > I did have reporting installed on this server once before but it was
> > > uninstalled. I tried uninstalling reporting services when I got this
> > error,
> > > then tried again but I get the same result. I've been deleting the
> > virtual
> > > directories, the program files folder, and the databases before trying
> > again.
> > > I also noticed that two com + packages are left behind. If you don't
> > remove
> > > them the next installation adds two more. I removed all of them and
tried
> > > again but still the same result. I don't possess any knowledge of web
> > > services so I'm not sure where to look next.
> > >
> > > Can anyone help please?
> > >
> > > --
> > > -Jeff
> >
> >
> >|||Excellent!!!! That did it. I could swear I'd already tried that and almost
replied with that, but I thought I should try again. I wonder if I tried
that before I deleted the extra com + packages. Is that possible? Do you
understand what happened here, because it would be nice to be able to explain
it to my co-workers?
Thanks so much,
-Jeff
"Brian Hartman [MSFT]" wrote:
> Try the following: rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > Reporting Services Error
> > ----
> --
> >
> > The report server cannot decrypt the symmetric key used to access
> sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content and then restart the service.
> > Check the documentation for more information. (rsReportServerDisabled) Get
> > Online Help
> > Bad Data.
> >
> > ----
> --
> > Microsoft Reporting Services
> >
> >
> >
> >
> > "Brian Hartman [MSFT]" wrote:
> >
> > > What error message do you see when viewing
> http://localhost/reportserver?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > I am trying to install SQL Reporting Services on a Windows Server 2003
> box
> > > > that is running Sharepoint Services 2.0.
> > > >
> > > > When you run the install you are warned that you will need to manually
> > > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > > documentation. In the rssetup.chm there is an article entitled
> > > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > > Windows SharePoint Services". I followed these instructions, but when
> I
> > > get
> > > > to the last step where you run rsactivate, I get an error:
> > > >
> > > > Failure starting the web service:
> > > > The service is already activated.
> > > >
> > > > I did have reporting installed on this server once before but it was
> > > > uninstalled. I tried uninstalling reporting services when I got this
> > > error,
> > > > then tried again but I get the same result. I've been deleting the
> > > virtual
> > > > directories, the program files folder, and the databases before trying
> > > again.
> > > > I also noticed that two com + packages are left behind. If you don't
> > > remove
> > > > them the next installation adds two more. I removed all of them and
> tried
> > > > again but still the same result. I don't possess any knowledge of web
> > > > services so I'm not sure where to look next.
> > > >
> > > > Can anyone help please?
> > > >
> > > > --
> > > > -Jeff
> > >
> > >
> > >
>
>|||I don't think the COM+ changes had anything to do with this. At some point,
you ran or installed something that reset the password on your ASPNet
account. Installing a version of the .Net framework will do this. So will
running aspnet_regiis. When the password is reset (reset = changed without
supplying the original one) on an account, the decryption keys associated
with that account are lost. There is probably an event in your windows
event log that indicates this happened.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:61D89FDE-0F89-4319-AB1A-F7D8C1462E07@.microsoft.com...
> Excellent!!!! That did it. I could swear I'd already tried that and
almost
> replied with that, but I thought I should try again. I wonder if I tried
> that before I deleted the extra com + packages. Is that possible? Do you
> understand what happened here, because it would be nice to be able to
explain
> it to my co-workers?
> Thanks so much,
> -Jeff
> "Brian Hartman [MSFT]" wrote:
> > Try the following: rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > > Reporting Services Error
> >
> ----
> > --
> > >
> > > The report server cannot decrypt the symmetric key used to access
> > sensitive
> > > or encrypted data in a report server database. You must either restore
a
> > > backup key or delete all encrypted content and then restart the
service.
> > > Check the documentation for more information. (rsReportServerDisabled)
Get
> > > Online Help
> > > Bad Data.
> > >
> >
> ----
> > --
> > > Microsoft Reporting Services
> > >
> > >
> > >
> > >
> > > "Brian Hartman [MSFT]" wrote:
> > >
> > > > What error message do you see when viewing
> > http://localhost/reportserver?
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights
> > > >
> > > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in
message
> > > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > > I am trying to install SQL Reporting Services on a Windows Server
2003
> > box
> > > > > that is running Sharepoint Services 2.0.
> > > > >
> > > > > When you run the install you are warned that you will need to
manually
> > > > > initialize SQL Reporting because of Sharepoint and are referred to
the
> > > > > documentation. In the rssetup.chm there is an article entitled
> > > > > "Troubleshooting a Side-by-Side Installation of Reporting Services
and
> > > > > Windows SharePoint Services". I followed these instructions, but
when
> > I
> > > > get
> > > > > to the last step where you run rsactivate, I get an error:
> > > > >
> > > > > Failure starting the web service:
> > > > > The service is already activated.
> > > > >
> > > > > I did have reporting installed on this server once before but it
was
> > > > > uninstalled. I tried uninstalling reporting services when I got
this
> > > > error,
> > > > > then tried again but I get the same result. I've been deleting
the
> > > > virtual
> > > > > directories, the program files folder, and the databases before
trying
> > > > again.
> > > > > I also noticed that two com + packages are left behind. If you
don't
> > > > remove
> > > > > them the next installation adds two more. I removed all of them
and
> > tried
> > > > > again but still the same result. I don't possess any knowledge of
web
> > > > > services so I'm not sure where to look next.
> > > > >
> > > > > Can anyone help please?
> > > > >
> > > > > --
> > > > > -Jeff
> > > >
> > > >
> > > >
> >
> >
> >|||On the start menu go to microsoft sqlserver then to reporting services
and open the help. click in installing notification services and you
will find the pathes there.

RSActivate Error

I am getting the following error when attempting to run RSActivate to add a
server to a web farm:
Failure starting the web service:
The local NT service is not activated
The log file contains the following entries:
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!7c8!08/17/2004-10:30:11:: 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): -2147159550
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!7c8!08/17/2004-10:30:15:: 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): -2147159550
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(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng 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.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()What error do you see in the Windows service log file?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> I am getting the following error when attempting to run RSActivate to add
a
> server to a web farm:
> Failure starting the web service:
> The local NT service is not activated
> The log file contains the following entries:
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!7c8!08/17/2004-10:30:11:: 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): -2147159550
> 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!7c8!08/17/2004-10:30:15:: 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): -2147159550
> 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(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng 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.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>|||Here is what I see in the Windows service log file:
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
public key
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT Service
not activated
ReportingServicesService!library!764!8/17/2004-10:29:51:: 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.
ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
start service again...
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> What error do you see in the Windows service log file?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > I am getting the following error when attempting to run RSActivate to
add
> a
> > server to a web farm:
> >
> > Failure starting the web service:
> > The local NT service is not activated
> >
> > The log file contains the following entries:
> >
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > Activating web service via RPC.
> > w3wp!library!7c8!08/17/2004-10:30:11:: 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): -2147159550
> > 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!7c8!08/17/2004-10:30:15:: 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): -2147159550
> > 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(Stri
> > ng key)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > (String name)
> > at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > ng 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.RenderPageCon
> > tent()
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
>|||Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:upNDrRJhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Here is what I see in the Windows service log file:
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT
Service
> not activated
> ReportingServicesService!library!764!8/17/2004-10:29:51:: 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.
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
> while starting service. Error:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
> start service again...
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> > What error do you see in the Windows service log file?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> > news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > > I am getting the following error when attempting to run RSActivate to
> add
> > a
> > > server to a web farm:
> > >
> > > Failure starting the web service:
> > > The local NT service is not activated
> > >
> > > The log file contains the following entries:
> > >
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
> user:
> > > NT AUTHORITY\NETWORK SERVICE
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not
activated
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > > Activating web service via RPC.
> > > w3wp!library!7c8!08/17/2004-10:30:11:: 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): -2147159550
> > > 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!7c8!08/17/2004-10:30:15:: 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): -2147159550
> > > 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(Stri
> > > ng key)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > > (String name)
> > > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > > name)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > > ng 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.RenderPageCon
> > > tent()
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > >
> > >
> >
> >
>

rsactivate error

I tray of run the rsactivate, show me the error.
*******************************************************
C:\>rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rsreportserver.config"
Failure starting the web service:
The local NT Service is not activated 0x800a0bcd
*******************************************************
I followed the installation instruction and the proccess that I attached
below.
*******************************************************
" Customer gave full permissions to IUSR, IWAM, and ASPNET users on the
following key using regedt32 and reinstalled SQL Server Reporting
Services successfully.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application"
Another case, the solution was:
"Since my default port does not use port 80, I had to change both the
server.config and rswebapplication.config files to use a different port. I
then ran the rsactivate command and all is now well."
I hope one of these will resolve your issue too.
From your descriptions, I understood that you cannot access Report server
and Report Manager via the web. Have I understood you? Correct me if I was
wrong.
First of all, what the error message from setup application. Was it "Setup
could not initialize the report server. You must manually initialize the
report server before using it for the first time. For more information, see
the Reporting Services setup documentation."?
Secondly, please make sure that your Reporting Services Startup Account was
main account and it is also a part of the Local Admins group on the machine.
Based on my scope, it seems like something was wrong with the event source
Report Manager from log files and it likes an permission issue. Please take
the steps below and tell me what happened
1. go to http://localhost/ReportServer What's the error message? I expected
it to be "Event source: Report Manager does not exist"
2. run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
assuming .net was installed in C:\WINDOWS\Microsoft.NET\)
3. open C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file. Search for this tag,
<InstallationID> and take the GUID (For example, the GUID for me is
{93850a3c-a856-4ce9-af25-6b3cdaa98dd8})
4. Use the GUID that we got before and try to remove the keys in the table
like this
RSKEYMGMT -R "{<guid>}"
5. Then run RSACTIVATE -C "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" > (make
sure the path is the one you installed Reporting Services)
If there is any error message shows here, please let me know and it is very
importantHi Antonio,
Sorry for the delay.
1. Run rskeymgmt with the -d argument to delete all encrypted content. You
can type rskeymgmt -? to get help about specific arguments.
2. Run rsconfig utility to specify report server connection information
(you must specify these arguments: -s, -d, -a, -u, -p). You can type
rsconfig -? to get help about specific arguments.
3. Restart both IIS and the ReportServer Windows service.
4. Run rsactivate utility to activate the server (you must specify these
arguments: -c, -u, -p). For argument -c, enclose the path information in
double-quotation marks. You can type rsactivate -? to get more help about
specific arguments.
Additionally, is it possible for you to reinstall the Reporting Services?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!sql

RSActivate - how do I run it successfuly?

I am getting an error...
"The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)"
I went to the MSDN site to find a fix...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
When I use rsactivate regardless of the switch I get...
Either the WMI provider or the path to the local config file must be specified
I have used the path to the BINN and the path to the rs config files, none
work.
Can you please send me the correct syntax and/ro path and/or utility?
Sincerelly and crossing my fingers that you will respond,
Vic ZDid you find a solution for your problem? I have a similar problem and havnt
found any good answers...
"DragonVic" wrote:
> I am getting an error...
> "The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated)"
> I went to the MSDN site to find a fix...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
> When I use rsactivate regardless of the switch I get...
> Either the WMI provider or the path to the local config file must be specified
> I have used the path to the BINN and the path to the rs config files, none
> work.
> Can you please send me the correct syntax and/ro path and/or utility?
> Sincerelly and crossing my fingers that you will respond,
> Vic Z

RSActivate

I have just installed RS (Standard Edition on Win2K. SQL instance on same
server). At the end of install, I got a dialog that said: Setup could not
initialize the report server. You must manually initialize the report
server before using using it for the first time..
I ran:
rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
password
It returned:
The command completed successfully
I then ran:
rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
It returns:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) .
I appreciate any help on this. Thanks!Hi Todd!
Did you find a solution? I have the same problem.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=89f0d955-4f23-47a2-886b-dc3a6d8ec457&cat=en-us-msdnman-eprise-sql&lang=en&cr=US&sloc=en-us&m=1&p=1#top
thx, yara
"Todd" wrote:
> I have just installed RS (Standard Edition on Win2K. SQL instance on same
> server). At the end of install, I got a dialog that said: Setup could not
> initialize the report server. You must manually initialize the report
> server before using using it for the first time..
> I ran:
> rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
> password
>
> It returned:
> The command completed successfully
>
> I then ran:
> rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
>
> It returns:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548) .
>
> I appreciate any help on this. Thanks!
>
>