Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
tutorial:adm:mssql_database_support [2020/06/24 15:09]
apeterova domain user note 		tutorial:adm:mssql_database_support [2021/03/05 17:15]
apeterova NTLM
Line 126: Line 126:
 8. Finally, restart the Apache Tomcat8 service so all changes take place. 8. Finally, restart the Apache Tomcat8 service so all changes take place.
  
 +=== Windows Authentication with NTLM ===
  
 +If you need to use Windows Authentication but can't use the integrated authentication as above (e.g. you are not running IdM on Windows), it's possible to use [[https://docs.microsoft.com/en-us/sql/connect/jdbc/using-ntlm-authentication-to-connect-to-sql-server?view=sql-server-ver15|NTLM authentication]]. You will explicitly set username and password.
  
 +Example properties:
 +<code properties>
 +spring.datasource.url=jdbc:sqlserver://xsqlserver123\CZECHIDM:1433;databaseName=bcv_idm_storage;integratedSecurity=true;authenticationScheme=NTLM;domain=yourdomain.tld
 +spring.datasource.username=someserviceuser
 +spring.datasource.password=somepassword
 +spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
 +spring.datasource.test-on-borrow=true
 +spring.datasource.validationQuery=SELECT 1
 +</code>
 +
 +The example is valid for SQL server running on the server "xsqlserver123", instance "CZECHIDM", database "bcv\_idm\_storage", domain "yourdomain.tld". Note that you don't specify the domain in the username.
  
 ==== Scheduler setup (quartz.properties) ==== ==== Scheduler setup (quartz.properties) ====
  • by doischert