I'm starting to hyperventilate here. We have a farm set up with a SQL
2008 cluster, two SP app servers, and two WFEs. The DB server is running
SSRS (as you might expect) and I have the reporting services add-in running
on all necessary SharePoint machines.
However, when I configure Reporting Services integration in Central Admin,
it completes with the following error in the "WSS_WPG Membership" section:
"There was an error when adding [companydomain]\[sqlUser] to the WSS_WPG
Windows group on [database server] .The group name could not be found"
This sounds suspiciously like an indication that I need to install
SharePoint on the database cluster. Is that true? The documentation is
sketchy and my Googling yields mixed results, largely geared toward SP2007.
Anyone?