View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005970 | SymmetricDS | Bug | public | 2023-09-05 00:49 | 2023-09-13 17:12 |
| Reporter | Vyshakh | Assigned To | pmarzullo | ||
| Priority | high | ||||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.14.9 | ||||
| Summary | 0005970: Azure SQL - Allow Symmetric DS to connect to Azure SQL using azure active directory authentication | ||||
| Description | Hi Team, We are in the process of using Symmetric DS to sync data from on-prem to Azure SQL, For connectivity to Azure we could find only option for username and password auth. Is there a way to connect to Azure SQL using active directory auth or any other means apart from username and password? Also, the config file uses jtds driver, for using sql driver , what should be the process? | ||||
| Steps To Reproduce | Connect to Azure SQL using auth methods other than username and password | ||||
| Tags | dialect: AzureSQL | ||||
|
|
Does this information resolve the issue? https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16 |
|
|
I had to add following jars into lib folder and WEB-INF\lib folder accessors-smart-2.4.9.jar asm-9.3.jar content-type-2.2.jar jackson-annotations-2.15.2.jar jackson-core-2.15.2.jar jcip-annotations-1.0-1.jar json-smart-2.4.10.jar lang-tag-1.7.jar msal4j-1.13.8.jar nimbus-jose-jwt-9.30.2.jar oauth2-oidc-sdk-10.7.1.jar slf4j-api-1.7.30.jar mssql-jdbc-12.4.1.jre8.jar Had to download microsoft jdbc driver Also use below in config db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver The Service Principal needs to be part of the azure ad admin group of sql server. db.url=jdbc:sqlserver://<sqlservername>.database.windows.net:1433;database=<dbname>;user=<ServicePrincipalApplicationID>;password=<ServicePrincipalKey>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryServicePrincipal;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880; |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-09-05 00:49 | Vyshakh | New Issue | |
| 2023-09-05 00:49 | Vyshakh | Tag Attached: AzureSQL | |
| 2023-09-06 17:20 | pmarzullo | Note Added: 0002378 | |
| 2023-09-06 17:20 | pmarzullo | Assigned To | => pmarzullo |
| 2023-09-06 17:20 | pmarzullo | Status | new => feedback |
| 2023-09-07 05:50 | Vyshakh | Note Added: 0002379 | |
| 2023-09-07 05:50 | Vyshakh | Status | feedback => assigned |
| 2023-09-13 17:12 | emiller | Status | assigned => closed |
| 2023-09-13 17:12 | emiller | Resolution | open => no change required |
| 2024-01-25 19:13 | admin | Tag Renamed | AzureSQL => dialect: AzureSQL |