FMSv11 on W2K8 - DSN will not Authenticate

Discussion created by karstyn on Apr 23, 2012
Latest reply on Apr 26, 2012 by karstyn
Customer has w2k8 server using FMSA 11.0.3.


ODBC (32 bit) System DSN to MSSQL works fine with file on desktop accessed with FMPRO locally.


The same file hosted on FMS prompts for user and password for DSN (it sees the server's system dsn's). The account info is stored in the External Data Source settings, and works in single user mode but not when hosted. Entering the correct username and password while the database is hosted will not authenticate to MSSQL.