We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Information required on SQL server Connection Integration

kbandi
New Contributor
New Contributor

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 ? 

5 REPLIES 5

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @kbandi,

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

rushikeshvartak
All-Star
All-Star

Currently one one AD Account is supported for Kerberos authentication 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

DixshantValecha
Saviynt Employee
Saviynt Employee

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.

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

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

rushikeshvartak_0-1702408939498.png

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

DixshantValecha
Saviynt Employee
Saviynt Employee

Thanks for the update @rushikeshvartak .