SQL Server 2005 default settings prevent ODBC connection
Posted on 2007-11-27
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.