Integrated security from IDM to MS SQL Database

[clotilde_martinez]

Hi IDM experts,

I have to connect IDM to a MS SQL Database, using the equivalent of "Windows authentication".

IDM is installed on a unix server. I think I got the overview of what to do, but i'm stuck. I added integratedsecurity=true to my db connexion string. I get the following error : This driver is not configured for integrated authentication.

Is is quite similar to what Matt had here : https://answers.sap.com/questions/11198836/sqljdbcauthdll-reference-in-a-dispatcher.html

First of all, I downloaded again my jdbc driver from microsoft website. I found the file to rename in the zip and put it in my java jre/bin folder. Is it the right place to put it? I guessed that since this java folder is in my dispatcher properties it should find it. I then restarted my dispatcher but no success.

So two questions : where should i put this sqljdbc_auth.dll and how should i declare it to be found?

Then, I think I'll probably be stuck again : should i also create a different dispatcher, ran by the windows user that should connect to the DB or is it another way to do it? Also, DB string connexions in IDM require a user and a passord, if i put in something wrong, will it be ignored? Or should i go through a script?

Thank you!

Clotilde

[alexanderbrietz]

Hi Clotilde,

sorry but I cannot provide insights with MSSQL as DB.

But I am using a custom jar with my dispatchers and I put it in the Identity_Center/Java directory from IDM runtime. There you can find other DLLs like sapjco3.dll as well.

For my custom jar I add it to dispatcher definition "DSE Class Path" in the Dispatcher Gui menue "Settings". I would guess that the DLL will get loaded automatically once it is in the right place.

From reading your post I have one question: Is your dispatcher instance on Windows? If it is on Unix as well I would assume that a DLL is not helpful! IMHO you would need a unix library as a pendant, most commonly ending on .so.

Reading the linked post I would recommend checking the link to MS page http://msdn.microsoft.com/en-us/library/ms378428.aspx. There should be an option to enable integrated authentication like Matt did with "mxmc_db;integratedSecurity=true;" as database parameter in the dispatcher settings of IDM 7.2.

HTH

Regards,

Alex