Solved

SQL Server 2005 default settings prevent ODBC connection

Posted on 2007-11-27
1
2,090 Views
Last Modified: 2008-08-30
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.
LAD
0
Comment
Question by:Lou Dufresne
1 Comment
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 20363251
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question