Monday, March 12, 2012

Reporting Services Install but then doesn't work (rsReportServerNotActivated)

Hi,
I'm installing the eval copy on Windows 2003 Enterprise with latest SP and
fixes. The reporting services install goes well. I can even hit the
https://myserver//reportserver url. However, I get the following:
a.. The report server installation is not initialized. Check the
documentation for more information. (rsReportServerNotActivated) Get Online
Help
a.. -2147159551
a.. 0x8007007f
I've followed all the books online/articles suggestions and nothing works.
When I try to activate manually via rsactivate using the -m option, I get:
Failure obtaining information from remote WMI provider:
System.Exception: Unable to find Reporting Services WMI namespace on
MyServerName.
Reporting Services may not be installed.
--> System.Management.ManagementException: User credentials cannot be
used for local connections
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.ReportingServices.RSActivate.RSActivate.GetRemotePropertiesFromWMI
()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.GetRemotePropertiesFromWMI
()
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
The above errors make no sense as I have reporting services installed and
the Report Serivce is running and the user credentials are the
administrators. So I don't know what this is all about.
When I use the -c option, I get the following:
Failure starting the web service:
System.Exception: Unable to connect to the database (-2147159551)
0x8007007f
--> 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,
BaseCmdLine instance)
This one too makes no sense. My web service is started and works just fine
using both SSL and non-secured requests. The database is also fine because
the dbs were created and the credentials were accepted by the setup.
And of course, the only article that seems to be pointed to is NOT available
at the moment. What a surprise. Sigh...
I've tried uninstalling and reinstalling, rebooting and nothing is working.
So, if anyone can mud through this long message and is able to point me in
the right direcction, that would be great. I appreciate any help you all
can offer. Thank you.
--
ArthurI found the problem and wanted to share it. I hope it would help someone
else.
Turns out the problem is the fact that I upgraded my server from Windows
2000 to 2003. See article 837128 (The Oledb32.dll file is not upgraded when
you upgrade your operating system from Windows 2000 to Windows Server 2003)
on support.microsoft.com.
Once I replace the Oledb32.dll with the correct version, voila! BTW, I did
not have to go through all steps in the article. I just copied the dll to
the two folders and that did the trick.
--
Arthur
"Arthur Yousif" <arthuryousif@.centurytel.net> wrote in message
news:uNjEDQNIFHA.4060@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm installing the eval copy on Windows 2003 Enterprise with latest SP and
> fixes. The reporting services install goes well. I can even hit the
> https://myserver//reportserver url. However, I get the following:
> a.. The report server installation is not initialized. Check the
> documentation for more information. (rsReportServerNotActivated) Get
Online
> Help
> a.. -2147159551
> a.. 0x8007007f
> I've followed all the books online/articles suggestions and nothing works.
> When I try to activate manually via rsactivate using the -m option, I get:
> Failure obtaining information from remote WMI provider:
> System.Exception: Unable to find Reporting Services WMI namespace on
> MyServerName.
> Reporting Services may not be installed.
> --> System.Management.ManagementException: User credentials cannot be
> used for local connections
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementScope.Connect()
> at
>
Microsoft.ReportingServices.RSActivate.RSActivate.GetRemotePropertiesFromWMI
> ()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.RSActivate.RSActivate.GetRemotePropertiesFromWMI
> ()
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] arg
s,
> BaseCmdLine instance)
> The above errors make no sense as I have reporting services installed and
> the Report Serivce is running and the user credentials are the
> administrators. So I don't know what this is all about.
> When I use the -c option, I get the following:
> Failure starting the web service:
> System.Exception: Unable to connect to the database (-2147159551)
> 0x8007007f
> --> 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,
> BaseCmdLine instance)
> This one too makes no sense. My web service is started and works just
fine
> using both SSL and non-secured requests. The database is also fine
because
> the dbs were created and the credentials were accepted by the setup.
> And of course, the only article that seems to be pointed to is NOT
available
> at the moment. What a surprise. Sigh...
> I've tried uninstalling and reinstalling, rebooting and nothing is
working.
> So, if anyone can mud through this long message and is able to point me in
> the right direcction, that would be great. I appreciate any help you all
> can offer. Thank you.
> --
> Arthur
>
>

No comments:

Post a Comment