Groups | Blog | Home
all groups > sql server reporting services > march 2005 >

sql server reporting services : Reporting Services Install but then doesn't work (rsReportServerNotActivated)


Arthur Yousif
3/4/2005 10:05:38 AM
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.

--
Arthur


Arthur Yousif
3/4/2005 12:41:33 PM
I 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


[quoted text, click to view]

AddThis Social Bookmark Button