Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • How to set up/configure Active Directory Windows Authetication for FME Desktop (for access to MSSQL databases)?

When attempting to connect to MSSQL Non-Spatial schema with Windows Authentication, I receive the following error: "Microsoft SQL Server <Non->Spatial Reader: Connection Failed. Connection string 'Provider=SQLNCLI11;DataTypeCompatibility=80;DataSource=<server>\\<iinstance>;User ID=;Password=*********',Provider error '(2147467259) Named Pipes Provider: Could not open a connection to SQL Server [2].'

Due to database security policy I need to use Windows and not SQL Server Authentication.

I am able to access the database with SQL Server Management Studio using Windows Authentication, and have checked server and db name are correct.

In the error message, the Windows 'UserID' value appears to be empty, does this mean I need to configure the AD user with FME? If so could someone explain how or refer me to instructions? Thank you.

When adding the reader or writer choose windows authentication. See screenshot:

I do this, but I am unable to connect to tables or schemas and receive error above.

I do this, but I am unable to connect to tables or schemas and receive error above.

@c_geraci , did you try both JDBC and or ADO and which one do you use?

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.