Problem with / in user name for IDBC data connector

[former_member214685]

Hi ,

I am working on SAP MII 12.1 and have created a data connector IDBC type SQL. The user I am using to access the database is defined with a <domain>/<user>. When I use this user the status of the data connector is error. When I replace it with a user with no / the status is running.

Is there a reason why the <domain>/<user> does not work?

Thanks

Isabel

[jcgood25 · Accepted solution]

JDBC connections require SQL Server users, not windows domain users. You will need to make sure you are using mixed mode authentication on the database server, and use a database user.

[former_member214685]

Thanks, that was useful and quick.