Reporting Services

I installed SQL 2005 Tools and everything appears to work except setting up the Reporting Services server. I started with my local instance of SQL Server 2000, SP2. I found a comment that said I needed SP4. I installed with no errors but when I check the version number still says SP2 even after a reboot. I still couldn't use it as RS instance.

I can write reports but without the RS server I can't publish them.

I then installed SQL 2005 Express which works fine and attached the Adventurework databases. But I still cannot designate an RS server.

No report servers were found on the specified machine. Details: Invalid namespace.

I believe there should be a RS service running but there is not. I tried reinstalling from both the original Tools directory and the Add/Remove Programs. In both cases, it says everything is alread installed.

I installed SQL Express 2005 w/ all the extras and now I have a local instance of Reports Services.

Reporting Service Problem

Hi Billy,
I have received the same error when installing the production version of rep
orting services onto Windows 2000 Server.
I tryed setting DTC to manual and then re-installing but still received the
same error message.
Do you have any other ideas?Hello,
Thank you for your posting in the community!
Based on the description, the issue is related to the installation of the Re
porting Service.If
you would, please post this question in the <microsoft.beta.reporting.servic
es.general>
newsgroup.
The reporting services newsgroup is primarily for issues involving the insta
lling problem of
Reporting Service. The reason why we recommend posting appropriately is you
will get
the most qualified pool of respondents, and other partners who read the news
groups
regularly can either share their knowledge or learn from your interaction wi
th us.
Thanks and have a good day!
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.