Error message when you use Microsoft Identity Integration Server or Microsoft Identity Integration Feature Pack to discover a connected directory: "Staging error" (829561)

MORE INFORMATION

When this behavior occurs, the following error message may appear in the event log: Server error 6301 The server encountered an unexpected error in the synchronization engine:
"ERR: MMS(2496): sql.cpp(5388): Query ({call mms_getmareadlock(?)}) performed with error
ERR: MMS(2496): sql.cpp(5441): EXECUTE permission denied on object 'sp_getapplock', database 'master', owner 'dbo'.
ERR: MMS(2496): sql.cpp(5449): hrError: 0x80040e09, dwMinor: 229
ERR: MMS(2496): sql.cpp(5597): SQL error: 42000, native: 229
BAIL: MMS(2496): sql.cpp(7304): 0x80040e09
BAIL: MMS(2496): sql.cpp(7077): 0x80040e09
BAIL: MMS(2496): sproc.cpp(2460): 0x80040e09
BAIL: MMS(2496): rwlock.cpp(427): 0x80040e09
BAIL: MMS(2496): nscsimp.cpp(2272): 0x80040e09
BAIL: MMS(2496): syncstage.cpp(394): 0x80040e09
BAIL: MMS(2496): syncstage.cpp(239): 0x80040e09
ERR: MMS(2496): syncstage.cpp(301): 0x80040e09 - staging failed 0x80040e09
ERR: MMS(2496): syncstage.cpp(302): Staging failed 0x80040e09: [CN=Kat Meadows,CN=Users,DC=epc,DC=com]
ERR: MMS(2496): syncmonitor.cpp(2492): SE: Rollback SQL transaction for: 0x80040e09 Microsoft Identity Integration Server 3.0.0692.14" By default, the MIIS service account has the correct Execute permissions through the Public security role. However, many SQL administrators lock down the Master database. This action denies access to the Public security role.