SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 connection failed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

slimjen
Yak Posting Veteran

61 Posts

Posted - 01/29/2013 :  23:21:46  Show Profile  Reply with Quote
Hi All,
I am using an evaluation of SQL SERVER 2008r2. I am using this on my PC to further my skills in SQL. I cannot create an ODBC so that I can connect an Access 2010 database.

Connection Failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired.

I've checked my configurations and everything but SQL SERVER Browser and Agent are running. Ihis in fact, these services are greyed out and I can't start them. but I've been told because not across network; not needed. Is this true? Can anyone help please?
Thanks

srimami
Posting Yak Master

160 Posts

Posted - 02/05/2013 :  08:10:57  Show Profile  Reply with Quote
This shouldn't be the case; try creating a link server and see if it works, if this works out ODBC should also work
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000