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

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

  • 19 February 2019
  • 1 reply
  • 23 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
Badge +2

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

28,669
Posts
109,357
Replies
36,531
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.