Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • How do I connect to a Microsoft SQL Server database using an Active Directory service account?

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

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


Community Stats

30,109
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie 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.