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?
Best Answer
Well, after I changed the Client Protocol on my ODBC to use SQL Named Pipes instead of TCP/IP it worked. Go figure