'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 |