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.
No comments:
Post a Comment