'Spring R2DBC - Connect to a SQL Server Database using Windows Authentication

trying to connect with MSSQL server with windows authentication using reactive(R2DBC) JDBC driver

#Data Source Configuration
spring:
  r2dbc:
    url: r2dbc:mssql://host:port
    name: dbname
    properties:
       domain: xyz
       authenticationScheme: NTLM
       integratedSecurity: true
       trustServerCertificate: false
       encrypt: true
    username: user
    password: password
    pool:
      enabled: true
      initial-size: 100
      max-size: 500
      max-idle-time: 30m
      validation-query: SELECT 

getting following error:

org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection; nested exception is io.r2dbc.mssql.ExceptionFactory$MssqlPermissionDeniedException: [18456] [S0001] Login failed for user 'user'.


Solution 1:[1]

Try using validation-query: SELECT 1

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 juanyee