AnsweredAssumed Answered

ODBC Authentication Works for FMP/FMPA but not From FMS

Question asked by DSKatSCL on Nov 28, 2016
Latest reply on Nov 29, 2016 by taylorsharpe

Client = FileMaker Pro Advanced 15 / Windows 7

Server Test Environment = FileMaker Server 15 / Windows 7

Server Working Environment = FileMaker Server 15 / Windows Server 2008 R2 Enterprise SP1

 

I have created a solution that is connected to an SQL Server data source through ODBC.  It works fine as a standalone
application and connects to the SQL database without issue.  When opened, it connects and automatically
authenticates the user and allows access to the SQL database.

 

However, I have now moved it to FileMaker Server 15 and when
opened, it will pop up an authentication bubble, asking for a user ID and
password.  I will not take my credentials
to open the connection to the SQL database.

 

I have tried this on two servers and I get the same
results.  I have set up both the client
and the server computers with the same ODBC System DSN and the tables show up
in the relationship table.

 

Is there a step I missed in setting this up or could
there be something I need to do to have the FileMaker Server and the SQL server
talk to each other?  Are there changes
that normally need to be made to make the connection to the SQL database work
or do I need to have something done by the DBA of the SQL Server to allow FMS
to communicate?

Outcomes