Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: cavagnaro on November 12, 2011, 07:50:44 PM

Title: Use windows account credentials to login to a MSSQL DAP
Post by: cavagnaro on November 12, 2011, 07:50:44 PM

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

Title: Re: Use windows account credentials to login to a MSSQL DAP
Post by: ExodusSS on November 13, 2011, 08:12:01 PM

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

Title: Re: Use windows account credentials to login to a MSSQL DAP
Post by: Steve on November 14, 2011, 02:18:41 PM

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?

Title: Re: Use windows account credentials to login to a MSSQL DAP
Post by: René on November 16, 2011, 09:31:56 PM

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.

Title: Re: Use windows account credentials to login to a MSSQL DAP
Post by: cavagnaro on November 16, 2011, 10:15:15 PM

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