Quick tip on SQL connection test

If you want to test a Windows auth on an ODBC SQL connection it is not possible to connect as other than the currently logged on user.

A quick tip for a workaround is to create an empty UDL file, like “test.udl”

Run CMD as the Windows/AD user in question with run as other user”

Run your test.udl file and you should be able to authenticate ODBC SQL as the user-account in question

More articles