# JDBC App with connection to Azure SQL

**URL:** <https://developer.sailpoint.com/discuss/t/jdbc-app-with-connection-to-azure-sql/2613>\
**Category:** IdentityIQ (IIQ)\
**Created:** [January 11, 2022, 7:47pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-app-with-connection-to-azure-sql/2613 "2022-01-11T19:47:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevinwoodbury](https://avatars.discourse-cdn.com/v4/letter/k/f07891/32.png) [@kevinwoodbury](https://developer.sailpoint.com/discuss/u/kevinwoodbury)\
**Post date:** [January 11, 2022, 7:47pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-app-with-connection-to-azure-sql/2613/1 "2022-01-11T19:47:54Z")

</div>

Has anyone successfully connected a JDBC connector with IdentityIQ 8.1+ to an Azure SQL Database? I’m using the JTDS Driver (although I could use a different driver if needed). The Username of the azure account contains an @ sign in the UPN which I think is throwing off the driver. Looking for advice on how to properly construct the connection string to connect to Azure SQL. Any suggestion / help would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![RobCarter](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@RobCarter](https://developer.sailpoint.com/discuss/u/RobCarter)\
**Post date:** [January 18, 2022, 8:28pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-app-with-connection-to-azure-sql/2613/2 "2022-01-18T20:28:44Z")

</div>

Hi Kevin,

I haven’t tried to connect 8.1+ to Azure SQL personally, but my experience with JTDS is that most of the newer versions of SQL Server do not support it out of the box. Based on a Google search for JTDS and Azure SQL troubleshooting, I see that several safeguards must be disabled in order for it to connect.

I’d recommend using the provided driver from Microsoft that is suitable for your environment: [Download - JDBC Driver for SQL Server | Microsoft Docs](https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=azuresqldb-current)

Hope this helps,

Rob C
