• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2114
  • Last Modified:

SQL Server 2005 default settings prevent ODBC connection

I am using SQLServer 2005 Express and trying to connect MS Access 2003 through ODBC. However, every time I try to make the ocnnection from within MS Access I get SQL Server Error 2, Connection Failed, Login timeout expired.  It goes on to say "When Connecting to Sql Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."

How can I change these default settings so that I can us an ODBC Connection.

Thanks in advance for your assistance.
Lou Dufresne
Lou Dufresne
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now