Hello, We use an Azure SQL Server instance with ActiveDirectoryPassword authentication. This is not currently supported in GeoTools, so I am working on adding it. The documentation for the connection string property can be found here:
https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-2017 The JDBC URL should look something like: jdbc:sqlserver://mydomain.database.windows.net ;DatabaseName=mydb;Authentication=ActiveDirectoryPassword This also requires a more recent version of the mssql-jdbc driver (min version 6, current version 7.2.1). Also, the mssql-jdbc driver is now hosted on the Maven central repository, so I have updated the pom.xml to pull it from there instead of requiring a manual install of the mssql-jdbc driver. My first pass at this feature is here: https://github.com/mattbsea/geotools/commit/ae28a8b54c89731d2e09c2c9d6e3744e1a68bbe3 I'm not sure how to test it. I ultimately need this in GeoServer. When I build the driver, I get gt-jdbc-sqlserver-22-SNAPSHOT.jar. So if I update my GeoServer build for version 22-SNAPSHOT, I think I'll get my latest code? I don't have much experience with java build systems... Any advice would be greatly appreciated! Regards, Matt [image: photo] *Matt Barclay* Senior Software Engineer 206.250.8960 | growers.ag
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
