Unable to Create ODBC Connection SQLState '08001' SQL Server 17

Gary Croxford
Gary Croxford used Ask the Experts™
Thank you for looking at my question,

Had a new server installed yesterday running MS SQL Server 2008 on SBS 2011.
Databases have been restored successfully - can see tables, views etc.

I tried to create on ODBC connection on the server and get:

Connection Failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBNetLib]ConnectionOpen
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNetLib]SQL Server does not exist or access denied

I don't know where to start looking - please help
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Disable firewall
From Start > All programs > Microsoft  SQL server > Configuration Tools > SQL server Configuration manager
Expand SQL server network Configuration > Select Protocol for (Ur SQL server)
Right hand pane Enable TCP\IP
Restart SQL service and try
Gary CroxfordOperations Support Analyst


Thank you Inderjeetjaggi, a real help - if I could award > 500 points I would

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial