I’m trying to connect Filemaker server 15 (developer version) to SQL Server 2008 SP4 without any luck.
Filemaker server 15 is running in virtual Windows Server 2012 R2 and SQL Server 2008 SP4 in Windows Server 2008 R2. Filemaker 14 Pro Advanced is used in Windows 10 laptop.
I have tried drivers from Windows 2012 R2 (Native client and SQL Server), Microsoft SQL Server Native Client Version 11.00.2100 (64bit) etc. System DNS driver connection test (Test Data Source) reports Conectivity OK but Filemaker server databases can’t connect to external sql server data. When I open remote filemaker database there is an additional box asking for user name and password for the ODBC data source (User name and Passoword)…?
Is there a working ODBC driver for our setup? SQL Server 2008 SP4 is not listed as certified data source for Filemaker Server 15 http://www.filemaker.com/support/technologies/sql.html .And my workstation is currently using older Filemaker 14 Advanced client.
By the way SQL database connection to the same SQL 2008 SP4 is working from old Filemaker server 2009/Windows 2003 SP2 –box without any problems (SQL driver 2000.86.3959.00/SQL Server ODBC Driver Version 03.86.3959).
Thank you for any help!