Unable to connect to SQL Server 2014 using ODBC

Question

I've set up my first SQL Server 2014 and I am trying to connect to it via ODBC, but I'm getting an error:

Microsoft SQL Server Native Client Version 11.00.2100

Running connectivity tests...

Attempting connection [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. [Microsoft][SQL Server Native Client 11.0]Login timeout expired [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

TESTS FAILED!

This is the first SQL Server I've set up, so I apologize if I've missed something rudimentary.

Have you properly set up tcp/ip? technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx — Joe C
Yes, I have those set up, correctly. I restarted the service to be sure. Still receiving the same error. — jstacy00

JVC JVC · Accepted Answer · 2016-05-31T15:28:50

Upgrade the driver. You need to use the 12.0.4100.1 or above driver to run SQL Server 2014

Unable to connect to SQL Server 2014 using ODBC

1 Answers