Skip to main content
Question

How do I connect to a Microsoft SQL Server database using an Active Directory service account?

  • February 19, 2019
  • 1 reply
  • 190 views
A

The SQL Server database I'm connecting to won't support database authentication (policy), so I got a AD service account created, but I can't find an option where I can use Windows Authentication, but I can still enter in the credentials (they are greyed out when you choose Windows Authentication).

FYI: I'm using FME 2018.1

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    M
    Forum|alt.badge.img+2
    • markatsafe
    • February 20, 2019

    The Active Directory Authentication uses your current windows user account, so the user a password are disabled in the connection parameters. FME SQL Server reader/writer help - see under Authentication

    Community Stats

    32,207
    Posts
    122,303
    Replies
    39,891
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.