Gary Croxford
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]Connectio nOpen
(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
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]Connectio
(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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER