White Rabbit w/ MSSQL Server w/ Windows Auth and with JDBC Driver name in PATH not connecting

[WJMetcalfUNRMed]

Running Windows 10 Enterprise with MSSQL Server 15.0.4326.1. SSMC shows Windows Auth

Installed the JDBC driver with the auth file in the class path (bottom line contains the JDBC auth directory (click the black bar for fullscreen)

using these instructions

The database is "DB2_Mothership"

Since it's Windows Auth, no need to enter credentials. You can see the IP:Port. I can successfully ping this IP address, but I'm not sure if that means MSSQL Server is listening on that IP:PORT combo (I believe it does, but can always be schooled)

The popup says it's not configured for integrated authentication contrary to the JDBC driver instructions. I restarted WR to see if that might work, but no joy. Same with SSMS (though I did not stop/restart the database itself). Note the console has an earlier auth error not related (had the wrong folder name).

Troubleshooting JDBC/MSSQL Server connectivity issues:
https://learn.microsoft.com/en-us/sql/connect/jdbc/troubleshooting-connectivity?view=sql-server-ver16

I'm able to get WR to work with SAS tables just fine, btw.

[janblom]

Hi,

the authentication happens outside of WhiteRabbit, so for now, I have removed the "Bug" label from this issue.

I do not have a Windows / SQL Server setup available for testing (and if I did, it might still not match your environment).

Maybe others have experienced (and solved) this issue, and can chime in.

Alternatively, you could go through the suggestions mentioned here.

In case of success, please mention the solution here as it might help others.

Hope this helps,
Jan