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

AI agents

OpenClaw: The AI Agent That Lives on My Machine What is OpenClaw? Think of it as a personal assistant that doesn’t

Read More »