I am trying to install reporting services and join it into existing service farm.
Main MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc.
We are using same domain account to run sharepoint services and reporting services.
I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.
Either way, it wont work for me:
If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc....
I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error
If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.
If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open
(moss2k7/ReportServer - /
View Complete Post