Possible ways to Connect to a Database using SPN

[Mohit_Sanka]

Hi All,

We have a use case where we need to use SPN details to connect to a Database. We tried to use the Database connector in Saviynt but it failed.

Kindly help us with possible options to use an SPN to connect to a Database in Saviynt.

Thanks & Regards,

Mohit

[Mohit_Sanka]

The Database we are trying to connect is a SQL database hosted on Azure cloud.

[rushikeshvartak]

You can connect to SPN using normal authentication or Kerberos based authentication,

Please provide screenshot 

[Mohit_Sanka]

Hi Rushikesh,

Are you referring to Local Authentication, if not Can you help us with a sample for normal authentication?

Thanks & Regards,

Mohit

[rushikeshvartak]

[Mohit_Sanka]

Hi Rushikesh,

Thanks for sharing the sample of Kerberos. But we don't want to use a User & password our use case wants us to use SPN (client ID and Secret) to connect to the DB.

Can we connect to the DB using SPN client id and secret or is Kerberos is the only way to connect.

Regards,

Mohit.

[rushikeshvartak]

if your authentication will be done by AD  then you need to use Kerberos . When you login manually do you add secret?