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

Dynamic botnet filter

We can utilize dynamic botnet filters on firewalls and specific services can be called upon dynamically. On Github there are several

Read More »