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
  • 170 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

    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

    Reply


    Helpful Members This Week

    Community Stats

    31,134
    Posts
    118,036
    Replies
    38,876
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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.