Hi,
While using Liquibase for connecting MSSQL for specific database using integratedsecurity, I am getting error as shown below.
“Unexpected error running Liquibase: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database “Test” requested by the login. The login failed. ClientConnectionId:499723ca-6d22-4f54-b91d-cbf323caab81”
Parameters used are:
liquibase.integration.commandline.Main
–driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
–username=domain\testuser
–password=****
–url=jdbc:sqlserver://testsqlserver:1433;database=Test;integratedSecurity=true;
When we verify in MSSQL logs, we could see user id thats used for login as “NT AUTHORITY/SYSTEM”
Logs:
2020-12-08 12:58:33.25 Logon Error: 18456, Severity: 14, State: 38.
2020-12-08 12:58:33.25 Logon Login failed for user ‘NT AUTHORITY\SYSTEM’. Reason: Failed to open the explicitly specified database ‘Test’. [CLIENT: XXXXX]
Could you please let me know how to resolve this issue.