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.
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
Hope this helps,
Rob C