# Windows Authentication: Microsoft SQL Server

**URL:** <https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796>\
**Category:** SHF Discussion and Questions\
**Tags:** sailpoint-identity-security, connectors\
**Created:** [November 6, 2024, 2:28pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796 "2024-11-06T14:28:08Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![nadhikari\_identitynow](https://avatars.discourse-cdn.com/v4/letter/n/958977/32.png) [@nadhikari\_identitynow](https://developer.sailpoint.com/discuss/u/nadhikari_identitynow)\
**Post date:** [November 6, 2024, 2:28pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/1 "2024-11-06T14:28:08Z")

</div>

Hello Experts,

I am trying to connect ISC with MS SQL server using the out-of-the box connector available in SailPoint ISC. We are trying to use Windows Authentication.

We have followed some of the guidance provided here in the community:

> [@MSSQL direct connection windows integrated](https://developer.sailpoint.com/discuss/t/mssql-direct-connection-windows-integrated/24723):
>
> Attempting to establish an MSSQL direct connection with windows authentication and there are lots of points referencing SQLJDBCdriver.config and krb5.config but all of them seem to assume a level of familiarity with these files and their structure that I do not have. Are there any kind of examples that someone could point me to on either how to write these or examples that have dummy configuration in them?

> [@ISC/MSSQL/Kerberos integration \[unable to obtain principal name for authentication\]](https://developer.sailpoint.com/discuss/t/isc-mssql-kerberos-integration-unable-to-obtain-principal-name-for-authentication/58036):
>
> Hello All, Recently i’m working on itegration between ISC and MSSQL on-prem database. Our customer request us to use Windows Authentication so additional step is to authenticate to Kerberos service. However i’m receivig follwowing error: Error Received: \> [ConnectorException] [Error details] The server encountered an unexpected error while contacting target system. Please check the logs. Kerberos Login failed: Integrated authentication failed. ClientConnectionId:92149d5e-2afb-4b3e-a324-92…

The issue we are having is we are getting the “unable to obtain Principal Name …”.

The second link I have included here has very nice and step by step guide document from Brennen Scott that we were trying to follow: However,  
We won’t be able to use the same service account that runs the MSSQLSvc and have the right SPN record as shown in the document.

We need to use a different windows account but we cannot set the SPN that it needs since it is used by the service account that runs the MSSQLSvc service in the server.

So, we are not able to move forward and hoping if anyone here faced the similar issue and had some insights on resolution. Any information helps.

Thanks in advance.

Thanks,  
Nischal

---

<div class="post-metadata">

**Author:** ![Shubhams\_009](https://avatars.discourse-cdn.com/v4/letter/s/ac8455/32.png) [@Shubhams\_009](https://developer.sailpoint.com/discuss/u/Shubhams_009)\
**Post date:** [November 6, 2024, 5:45pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/2 "2024-11-06T17:45:11Z")

</div>

Hi @nadhikari_identitynow,

In the past for OOTB connector (Microsoft SQL Server) we had the same requirments to use Windows account for AuthN so we used JTDS driver instead of JDBC and used below configs.

Auth Type: Windows AuthN  
DB URL: jdbc:jtds:sqlserver://:;domain=\<your\_domain\>integratedSecurity=true;useNTLMv2=true;  
Driver class: net.sourceforge.jtds.jdbc.Driver  
Jar file: jtds-1.3.1.jar (can be downloaded from [jTDS - SQL Server and Sybase JDBC driver - Browse /jtds at SourceForge.net](https://sourceforge.net/projects/jtds/files/jtds/))

Might worth a try to see what it pulls.

Thanks,  
Shubham

---

<div class="post-metadata">

**Author:** ![nadhikari\_identitynow](https://avatars.discourse-cdn.com/v4/letter/n/958977/32.png) [@nadhikari\_identitynow](https://developer.sailpoint.com/discuss/u/nadhikari_identitynow)\
**Post date:** [November 6, 2024, 5:58pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/3 "2024-11-06T17:58:56Z")

</div>

Hi Shubham,

Thank you for your response. Just to confirm, you are using generic JDBC connector and JTDS driver? Or you are using Microsoft SQL Server connector and JDTS Driver?  
Please confirm.

Thank you.

-Nischal

---

<div class="post-metadata">

**Author:** ![Shubhams\_009](https://avatars.discourse-cdn.com/v4/letter/s/ac8455/32.png) [@Shubhams\_009](https://developer.sailpoint.com/discuss/u/Shubhams_009)\
**Post date:** [November 6, 2024, 6:02pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/4 "2024-11-06T18:02:17Z")

</div>

We are using Microsoft SQL Server connector and JTDS Driver.

Thanks,  
Shubham

---

<div class="post-metadata">

**Author:** ![sk8er23](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sk8er23/32/19357_2.png) [@sk8er23](https://developer.sailpoint.com/discuss/u/sk8er23)\
**Post date:** [November 23, 2024, 1:01pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/5 "2024-11-23T13:01:49Z")

</div>

Did you ever resolve this?

---

<div class="post-metadata">

**Author:** ![nadhikari\_identitynow](https://avatars.discourse-cdn.com/v4/letter/n/958977/32.png) [@nadhikari\_identitynow](https://developer.sailpoint.com/discuss/u/nadhikari_identitynow)\
**Post date:** [November 26, 2024, 1:34pm UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/6 "2024-11-26T13:34:26Z")

</div>

No. We weren’t approved to use the open-source JTDs. SQL Authentication was eventually used.

---

<div class="post-metadata">

**Author:** ![baoussounda](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/baoussounda/32/13095_2.png) [@baoussounda](https://developer.sailpoint.com/discuss/u/baoussounda)\
**Post date:** [January 15, 2025, 8:37am UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/7 "2025-01-15T08:37:24Z")

</div>

@nadhikari_identitynow can you please confirm to me if the MSSQL connector work correctly for you ?

Currently, we to connect on MSSQL Database but i’m currently about which i can use (Microsoft SQL Server or JDBC connector). I have no experience with MSSQL Server

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 16, 2025, 8:37am UTC](https://developer.sailpoint.com/discuss/t/windows-authentication-microsoft-sql-server/88796/8 "2025-03-16T08:37:25Z")

</div>

Closed on March 16, 2025, 8:37am UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
