Link to home
Start Free TrialLog in
Avatar of Gary Croxford
Gary CroxfordFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Inderjeetjaggi
Inderjeetjaggi
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gary Croxford

ASKER

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