Use windows account credentials to login to a MSSQL DAP

[cavagnaro]

Hi guys,
I have a couple of new customers that are government entities and as that they are asking that Genesys connects to their MSSQL DBs using Active Directory users and not MSSQL inner users. I have tried to set it up and no luck, do any of you guys have any experience if this is doable and if so how?

Thanks

[ExodusSS]

Hi Cav...

Quick question - how do they currently interface AD Users with their MSSQL...?

I've seen "Genesys" set up as a "Dummy" End User on AD previously - that might help you...

ESS

[Steve]

I think that there are 2 questions here -
Can MSSQL do AD authentication? My instinct is yes it can, and a quick Google seems to back that up.

I think a more important one is how you will update your DAPs every month or so, when AD forces a password reset? Will you have any way of knowing that the PW is about to expire, before it does? And when it does where will it leave your solution?

[René]

Hi Cav,

Such configuration is not officially supported but it should work. You will need to run DB Server under dedicated user account that has access to SQL Server and configure SQL Server to force Windows authentication over SQL login authentication.

R.

[cavagnaro]

Ah...nice input! Will try!
Thanks!