0 Replies Latest reply: May 30, 2017 3:47 PM by John O'Brien RSS

    QV Distribution Service multiple AD IDs for SQL Server queries with integrated Windows auth?

    John O'Brien

      Is it possible to have one QV v12 Distribution Service reload documents using ODBC connections to SQL Server DBs using 2 different AD IDs with integrated Windows auth?

      The network security team wants the QV Distribution Service to logon as AD account (ex. Domain\QVPubSvc).  The DB administrators want queries to SQL Server to use different AD accounts (ex. Domain\QVUser01, Domain\QVUser02), and all the databases use Integrated Windows Authentication only.

      Any solutions would be appreciated.