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.