SQL Server - Connect via SSMS works fine, but ODBC fails

Question

I have a SQL 2016 Express instance, and I can connect to this fine using sqlsrv_connect() from within PHP. However, when I try to create a ODBC connection it fails. I get the error message "SQL Server does not exist or access denied".

I have verified that the IP address matches that of the machine SQL is installed on via SQL Server Config Manager -> SQL Server Network Config -> TCP/IP -> IP Address tab. I have also completed turned off the Firewall to see if it was causing the issue, which didn't work either. I can connect just fine using SSMS.

Any ideas?

Does ODBC fail from the same systems where PHP and SSMS are accessing from? — K. Brian Kelley, Nov 30 '17 at 15:17
Well, after I changed the Client Protocol on my ODBC to use SQL Named Pipes instead of TCP/IP it worked. Go figure. — Phil, Nov 30 '17 at 16:11
You should consider doing a self-answer, since you solved it yourself. — Katherine Villyard, Nov 30 '17 at 20:23

score 2 · Answer 1 · answered Nov 30 '17 at 20:29

2

Well, after I changed the Client Protocol on my ODBC to use SQL Named Pipes instead of TCP/IP it worked. Go figure

answered Nov 30 '17 at 20:29

Phil

203
1
2
9

SQL Server - Connect via SSMS works fine, but ODBC fails

1 Answers1