3 Replies Latest reply on Nov 29, 2016 6:38 AM by taylorsharpe

    ODBC Authentication Works for FMP/FMPA but not From FMS

    DSKatSCL

      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?