ODBC Connection Using Wrong Auth Method

  • If you get rid of the ODBC DSN, does it still try to connect to SQL Server? If so, then it's making a direct connection using information stored in the registry, in a .config file, in a .ini file or something. That would be the first thing I would try.

    K. Brian Kelley
    @kbriankelley

  • I just solved it last night, but hadn't had a chance to update this thread. It was indeed an .ini file that they forgot to check. It has the initial connection string in it. The app makes one connection to the DB with this connection string, then loads the user's business rules to use for subsequent connections. The config file had "trusted_connection=yes" in it and it should have had "uid=xxxxxxx". I found it by doing a filemon when the application was launching.

    Thanks for the reply.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply