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

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
(Connect())
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
Gary CroxfordOperations Support AnalystAsked:
Who is Participating?
 
InderjeetjaggiCommented:
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
0
 
Gary CroxfordOperations Support AnalystAuthor Commented:
Thank you Inderjeetjaggi, a real help - if I could award > 500 points I would
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.