and more in a single search tool across platforms. Read the announcement here. |
12/05/2023 05:22 AM - edited 12/08/2023 07:34 AM
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 ?
12/06/2023 11:04 PM
Hi @kbandi,
We are checking on this and we will keep you posted .
12/07/2023 07:29 PM
Currently one one AD Account is supported for Kerberos authentication
12/12/2023 06:01 AM - edited 12/12/2023 06:02 AM
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.
12/12/2023 11:19 AM - edited 12/12/2023 11:22 AM
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
12/13/2023 02:12 AM
Thanks for the update @rushikeshvartak .