ODBC using fixed Windows login from non-AD computer? Possible? RRS feed

  • Question

  • We have an outside company that needs access to one of our databases, which is hosted on a HAG.  They want a simple SQL user created, but we try to avoid SQL users in favor of Windows/Domain users/groups.  Domain auth is easier, as there are no messy SID's to line up across servers, or to migrate when it's new server season.

    So, this company says they are using an ODBC connection.  Which leads me to ask:  Is there a way to force/fudge a SQL ODBC connection into using a specific "Windows login/authentication" for a System DSN, and when that system is on a foreign network and has no AD trust relationship?

    Not really expecting anything but a "not possible" on this one, but if it were it'd be cool to learn something new.

    Thanks in advance.

    Thursday, November 7, 2019 4:09 PM

All replies