Information required on SQL server Connection Integration

[kbandi]

Hi Team , 

We have multiple sql server ,

and we have connected the 1st sql server by using keytab file and  SQLJDBCDriver.conf.

The sql jdbc conf file is below

SQLJDBCDriver {
com.sun.security.auth.module.Krb5LoginModule required
useTicketCache=false
useKeyTab=true
doNotPrompt=true
keyTab="/saviynt_shared/saviynt/ConnectorFiles/SVC_AZ_LNLTEST.keytab"
principal="MSSQLSvc/SVC_AZ_LNLTEST@NEWMONT.NET";
};

For the next sql connection can you use same driver file with 2nd keytab added by using cama separation like Multiple keytabs  in same SQL driver file . 

Can you please suggest any other way to connect or we can proceed by the above method ? 

[DixshantValecha]

Hi @kbandi,

We are checking on this and we will keep you posted .

[rushikeshvartak]

Currently one one AD Account is supported for Kerberos authentication 

[DixshantValecha]

Hi @kbandi,

I will also recommend you to use the below mentioned approch:-

The sql jdbc conf file is below

SQLJDBCDriver {
com.sun.security.auth.module.Krb5LoginModule required
useTicketCache=false
useKeyTab=true
doNotPrompt=true
keyTab="/saviynt_shared/saviynt/ConnectorFiles/SVC_AZ_LNLTEST.keytab"
principal="MSSQLSvc/SVC_AZ_LNLTEST@NEWMONT.NET";
};

Regarding your second inquiry about utilizing the same driver file with a second keytab added using a comma-separated format, such as "Multiple keytabs in the same SQL driver file," I am currently consulting with our internal team to determine the feasibility of this approach. I will provide you with an update once I have received clarification on this matter.

[rushikeshvartak]

In startup only 1 config file is supported for keytab & .conf file

https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Appendix-WIP.htm

https://docs.saviyntcloud.com/bundle/DB-v2020x/page/Content/Appendix.htm

[DixshantValecha]

Thanks for the update @rushikeshvartak .