I have created a filemaker pro 12 database using a sql server external data source. When I host the file on filemaker server 12 and open it on filemaker go I am prompted to enter an account name and password to login to the sql server database. Even though I originally setup the filemaker database to login automatically with a specified username and password, i enter in any username and password that should work to log into the sql server and I get this error message:
ODBC Error: [Microsoft][SQL Natvie Client]Named Pipes
Provider: No process is on the other end of the pipe.
[Microsoft][ODBC Driver Manager] Driver's
[MicrosoftSQL Native Client]Communication link failure
Does anyone know what is going on? Please help
Thanks everyone for your help. I discovered that my problem was that I had not entered the SQL username and password when I created the DSN, I only entered the username and password in the filemaker database when created the External Data Source. Now everything works perfectly.