Microsoft KB Archive/829561

= Error message when you use Microsoft Identity Integration Server or Microsoft Identity Integration Feature Pack to discover a connected directory: &quot;Staging error&quot; =

Article ID: 829561

Article Last Modified on 2/23/2007

-

APPLIES TO


 * Microsoft Identity Integration Server 2003 Enterprise Edition
 * Identity Integration Feature Pack for Microsoft Windows Server Active Directory

-





SYMPTOMS
When you use Microsoft Identity Integration Server (MIIS) or Microsoft Identity Integration Feature Pack (IIFP) to discover a connected directory, you may receive the following error message:

Staging Error



CAUSE
This behavior may occur if the MIIS service account does not have Execute permissions to the following stored procedures in the Master database on the computer that is running Microsoft SQL Server that hosts the MIIS database:
 * sp_getapplock
 * sp_releaseapplock



WORKAROUND
To work around this behavior, make sure that the MIIS service account has Execute permissions to both the sp_getapplock stored procedure and the sp_releaseapplock stored procedure.



STATUS
This behavior is by design.



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:

&quot;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&quot;

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.

Keywords: kbprb KB829561

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.