• State Verified Answer
  • Replies 5 replies
  • Subscribers 96 subscribers
  • Views 2408 views
  • Users 0 members are here
Options
Related

Connect to MS SQL with AD account

Sergey Aksenov
over 3 years ago

Hello everyone.

I have silly question (not find any clue in doc's) - how to connect to MS SQL with AD credentials ?

JobService running as "Local System" in AD named domainA. MS SQL server run in AD named domainB and granted rights for special account domB\oneidm.

When i try to create synchronization project using domB\oneidm or oneidm@domB.com for connecting to SQL server:

red exclamation marks apear near "user"/"password" fields and can't  select any database.

there is no problem at the network or db level.

if specify sql server account for connecting every is fine.

Best regards

  • 0 over 3 years ago

    Sorry, but which connector are you referring to? I assume the native MSSQL connector? Which version are you using?

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    "Native Database Connector", then "SQL Server" (on "Select database system")

    One Identity Manager
    ********************************************************************************
    DBProductionLevel DEV
    QBMDBQueueProcess Slots max 13
    QBMDBQueueProcess Slots current 5
    DBQueue process disabled 0 0 - (100%)
    Jobqueues disabled 0 0 - (100%)
    Percentage of History 0 <= 5 % - (100%)
    Installed One Identity Manager Edition CCC (8.1.3.102) Installed without edition info
    Module and Version QBM (8.1.3.102) 2019.0001.0021.0300
    Module and Version DPR (8.1.3.102) 2019.0001.0021.0300
    Module and Version QER (8.1.3.102) 2019.0001.0021.0300
    Module and Version RMB (8.1.3.102) 2019.0001.0021.0300
    Module and Version RMS (8.1.3.102) 2019.0001.0021.0300
    Module and Version RPS (8.1.3.102) 2019.0001.0021.0300
    Module and Version TSB (8.1.3.102) 2019.0001.0021.0300
    Module and Version CAP (8.1.3.102) 2019.0001.0021.0300
    Module and Version POL (8.1.3.102) 2019.0001.0021.0300
    Module and Version ADS (8.1.3.102) 2019.0001.0021.0301
    Module and Version ATT (8.1.3.102) 2019.0001.0021.0300
    Module and Version CPL (8.1.3.102) 2019.0001.0021.0300
    Module and Version CCC (8.1.3.102) 2019.0001.0021.0300
    Module in use ADS yes yes - (100%)
    Module in use ATT no yes - (50%)
    Module in use CPL no yes - (50%)
    Module in use DPR yes yes - (100%)
    Module in use POL no yes - (50%)
    Module in use QBM yes yes - (100%)
    Module in use QER yes yes - (100%)
    Module in use RMB no yes - (50%)
    Module in use RMS no yes - (50%)
    Module in use RPS no yes - (50%)
    Module in use TSB yes yes - (100%)
    HDB in use No history database specified in DialogHistoryDB table history database(s) active - (40%)
    Queue configuration Queue = \DB; Cluster = 0; AutoUpdate = 1; ConfigImported = 1; Server = db.conto.com; Parent = <none>; Tags = One Identity connector; CSV connector; SQL processing server; Update server; JobServiceEnabled - (100%)
    Queue configuration Queue = \JOBSERVER; Cluster = 0; AutoUpdate = 1; ConfigImported = 1; Server = JobServer.conto.com; Parent = <none>; Tags = One Identity connector; Active Directory connector; CSV connector; Native database connector; SMTP host; SQL processing server; JobServiceEnabled - (100%)

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    Use Native Database Connector
    One Identity Manager Edition 8.1.3.102

    rely on thread:
    www.oneidentity.com/.../sql-connection-as-domain-service-account-8-1-2
    i should be use sql server login or run JobService with account domB\oneidm

    strange behavior on the forum - could not answer, had to use another account

  • +1 over 3 years ago in reply to Aksenov Sergey

    Did you notice that in the mentioned thread, the last post explains that the option shown is for Azure AD only?

    For Windows Integrated authentication you need to check the Windows Authentication checkbox.