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:

  1. Dan Oyuga AnneFebruary 2, 2009 at 8:51 PM

    It did not work for me

    ReplyDelete
  2. SajFebruary 3, 2009 at 11:49 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)