We help IT Professionals succeed at work.

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

Gary Croxford
Gary Croxford asked
on
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
Comment
Watch Question

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

Author

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