Details:
The log file shows:
SM~~16302~~Dynamics SL Message 16302: Fatal SQL Error
SQL trace shows:
The EXECUTE permission was denied on the object 'WebServiceAccess_Delete_TimeOutSessions', database 'TraneSystem', schema 'dbo'.
Cause: Bug 25023 - database maintenance sync ownership and security does not recreate or reassign rights to the TrustedWebService role
Resolution: Run the following script on the System db
IF not exists( select * from sysusers where name = 'TrustedWebService' and issqlrole = 1 )
begin create role TrustedWebService end
exec granttrustedwebservice
grant select on sldata to trustedwebservice --bug 24998
grant select on [messages] to trustedwebservice --bug 24998
-- app Db
IF not exists( select * from sysusers where name = 'TrustedWebService' and issqlrole = 1 )
begin create role TrustedWebService end
exec granttrustedwebservice