I am setting up a test server using Windows Server 2012. Overall things are good. I am having trouble with the ODBC driver.
I think I have done everything correctly.
- I opened port 2399 in the firewall. Inbound rule.
- Installed the drivers.
- Setup the DSN. When testing I keep getting Test Failed , Failed to connect to listener (3)
When connecting to the same ESS database with OSX running FMS using the same credentials everything is fine. The install instructions are very vague actually. I saw some mention of making sure some file/folder was read/write but I seem to have lost that note. I cannot find what the specific error is for though. The driver will connect to localhost and see FM databases, so I think the drivers are ok. I suspect this is something to do with the port on the FMS. Maybe I set that up wrong?
I tried setting up the DSN with the IP and hostname, but neither worked.