How to configure MIM Generic SQL Connector Schema 2 with a stored procedure?
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?