I have set up two MOSS farms. One is configured to provide Shared
Services to the other. The client farm is a simple 2 server farm
with all of MOSS running on one server and one running SQL. I am
getting am getting the following error on the SSP client WFE:
Insufficient SQL database permissions for user '' in
database 'SharePoint_Config' on SQL Server instance 'MOSSSql-
Parent'. Additional error information from SQL Server is included
below.
EXECUTE permission denied on object 'proc_getNewObjects',
database 'SharePoint_Config', schema 'dbo'.
Looking at the 'proc_getNewObjects' stored procedure in the Config
DB on the SQL server for the parent MOSS farm that is providing the
Shared service. There are no explicet permissions on the stored
procedure so only DBO can execute it, no account on the client farm
can execute it.
There is a SQL role named 'WSS_Content_Application_Pools' that
execute permission on manny of the other stored procedures and has
the accounts that I configured in users "Provide Shared Services" on
the Parent farm.
In a duplate test environment I have granted
the 'WSS_Content_Application_Pools' execute permissions on
the 'proc_getNewObjects' stored procedure and the error has gone
away.
With this said I have two questions:
1) Has anyone else run into this?
2) Will this void suportability of the system from MicroSoft?