I have set up a local System DSN for connecting to a SQL 2008 server. It works fine locally on Mac 10.8.4 or Windows 7 using FleMaker Advanced 12. I am able to see the live files and review the data.
I then set up the System DSN on the Windows 2008 R2 server. The DSN tested fine.
Now when I try to open that ESS connection on the hosted file, it asks me to authenticate and will not accept my user name and password. Is there something else that needs to be opened in order fort he hosted file to access the SQL source?