AD groups then user should be provisioned to other sources like MSSQL source

kalyannambi2010 · May 23, 2025, 9:47am

Hi @Arshad we are specifying Database URL: jdbc:sqlserver://Sample.e4abd739ac96.database.windows.net :1433;databaseName=Test;

Arshad · May 23, 2025, 9:56am

@kalyannambi2010 Hope you’ve went through the connector documentation of MS SQL. Documentation Link - https://documentation.sailpoint.com/connectors/microsoft/sql_server/help/integrating_ms_sql_server/connection_settings.html

The Database URL must not contain the table name parameter. Below is the format:

<jdbc:sqlserver://><[serverName][*instanceName*][:portNumber]]

Instead, there is a field below in the source config to provide the table name:

You might be having this field as blank assuming that you’ve provided the table name in the Database URL. But that’s the case for JDBC connector and not MS SQL connector.

Since your Included Databases field is blank, source is giving the error : Provide valid database name.

kalyannambi2010 · May 23, 2025, 10:05am

Hi @Arshad I have already provided value for “Included Databases” field still it throwing same error.

Thanks

Arshad · May 23, 2025, 10:11am

Remove the databaseName parameter from the Database URL field and retry provisioning again.

kalyannambi2010 · May 23, 2025, 10:21am

Hi @Arshad removed the databaseName parameter from the Database URL and getting same error.

I am not sure why it is creating multiple accounts are getting created but getting error like " Create Account Failed", " Add Entitlement Failed" and no roles/entitlements associated with the accounts.

Below is causing any issues?

Thanks