EXECUTE permission was denied on 'proc_putPendingDistributionList' - Sharepoint

I'm not sure if this is right, but it looks to me like a "double-hop"
problem. Essentially, it's what happens when you have your database on a
different server from IIS without Kerbros configured on your domain. Your
(or your process') user credentials don't "hop" around the network from
server-to-server like they should if Kerbros isn't installed and configured
on your domain. Unfortunately, I've been the victim of errors like this far
too many times since my company opted not to bother with Kerbros.

If it *used* to work, but doesn't now (with the configuration you currently
have), then it's not the double-hop problem...but maybe it helps point you in
the right direction.


"Eric" wrote:

> I'm getting this error when a site owner creates a new site. We're on MOSS
> Enterprise + SP1 + Infrastructure Update.
>
> Looked in the db and no explicit permissions are set up on that stored
> procedure.
> But the same goes for many of the other sibling procedures.
>
> Thanks for your help.
> ===============================
> Event Type: Error
> Event Source: Windows SharePoint Services 3
> Event Category: Database
> Event ID: 5214
> Date: 10/16/2008
> Time: 8:43:58 AM
> User: N/A
> Computer: SHAREPOINTSERVER
> Description:
> Insufficient SQL database permissions for user '' in database
> 'SharePoint_Config' on SQL Server instance 'SharePointDataBase'. Additional
> error information from SQL Server is included below.
>
> The EXECUTE permission was denied on the object
> 'proc_putPendingDistributionList', database 'SharePoint_Config', schema 'dbo'.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>