Hello, I am trying to configure GeoServer 2.15.0 to talk to our Azure SQL Server instance using ActiveDirectoryPassword authentication. I have installed the Microsoft SQLJDBC 7.2.1.0 driver, and I can see "Microsoft SQL Server" as an option in the datastore configuration page. However, when I configure my server, I get the following error:
java.lang.RuntimeException: Unable to obtain connection: Cannot create PoolableConnectionFactory (*Cannot open server "mydomain.net <http://mydomain.net>"* requested by the login. The login failed. My configuration looks like: Host: mydomain-test.database.windows.net Port: 1433 Database: my_database_test Schema: dbo User: my-readonly-acco...@mydomain.net Passwd: XxXxXxX In Python-land, the connection string looks like this: Driver={ODBC Driver 17 for SQL Server};Encrypt=yes;TrustServerCertificate=no;ConnectionTimeout=5; *Authentication=ActiveDirectoryPassword*;Server= mydomain-test.database.windows.net;Database=my_database_test;Uid= my-readonly-acco...@mydomain.net;Pwd=XxXxXxX; Is there any way to enable ActiveDirectoryPassword authentication in GeoServer? Thanks, Matt
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
