How to configure MIM Generic SQL Connector Schema 2 with a stored procedure?

Steven Johnson 21 Reputation points
2025-05-02T19:48:04.1466667+00:00

I'm trying to configure the MIM Generic SQL Connector (to MS SQL Server) using a stored procedure. On Schema 2 tab I've selected Stored Procedure and added the SP. Without adding anything else to this tab and selecting Next, I get an error stating:

Unable to retrieve configuration parameters from the extension: Exception from HRESULT: 0x80230721

I get that error twice and then this one:

Unable to retrieve schema: Exception from HRESULT: 0x80230721

I'm unable to continue further. The data from the SP is very simple--just 3 columns with the first one being the id number and the the second two being nullable strings. There are no parameters in the SP so am I assuming correctly that I don't need anything in that box? The stored procedure executes correctly running directly with the same account on SQL Server.

On the Schema 1 tab, I just selected Fixed Value with a value type of "person" since each row is for an identity. Do I assume correctly that this is ok?

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
839 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.