Solved

ODBC connection problem

Posted on 2011-09-04
5
453 Views
Last Modified: 2012-05-12
i have set up SQL Server Express 2005 as a backend and MS Access 2007 as a front end.  The operating system on both machines is Windows 7.  I have set the login and user name on the SQL Server.  I am trying to establish an ODBC connection between the Access 2007 to the SQL server and I keep getting an error message:
"Connection Failed
SQL State 01000
SQL Server Error 1385
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect())
Connection failed:
SQL State 08001
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist of access denied

I have this same system set up on XP boxes and no problems connecting using SQL server driver.

Please help.  Thanks.
0
Comment
Question by:Bergan2
  • 3
  • 2
5 Comments
 
LVL 51

Expert Comment

by:HainKurt
ID: 36481874
so you have 3 machines, one sql server 2 clients
one client can connect to sql using the same settings, the other is giving this error
is that right?
0
 
LVL 51

Expert Comment

by:HainKurt
ID: 36481876
have a look at this article from MS

http://support.microsoft.com/kb/328306
0
 

Author Comment

by:Bergan2
ID: 36481920
I have two machines set up the  with Access 2007 and SQL Express 2005 with  operating system Windows 7.  

The other machines I referred to are a different system entirely using XP as the operating system but the same SQL express 2005 and Access 2007 programs.  This system works.  
0
 

Accepted Solution

by:
Bergan2 earned 0 total points
ID: 36481950
I restarted the services on the SQL express 2005 and the problem is resolved.

Thanks.
0
 

Author Closing Comment

by:Bergan2
ID: 36515574
Thanks for your help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

791 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