Solved

ODBC connection problem

Posted on 2011-09-04
5
442 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now