Monday, February 2, 2009

SQL Server ODBC Connection Error

Are you getting the following error?

Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied

Very simple solution, give the correct servername (default is local).

For e.g. MYMACHINE\SQLEXPRESS
Posted by at

2 comments:

  2. Are you getting the same error? If not, please share your error message. Also check your firewall settings.

    ReplyDelete

Subscribe to: Post Comments (Atom)