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

DISM repair Windows Server 2016

Repair Windows Server 2016 with DISM dism /online /cleanup-image /scanhealth dism /online /cleanup-image /checkhealth dism /online /cleanup-image /restorehealth /source:WIM:d:sourcesinstall.wim:2 /limitaccess sfc

Read More »