Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 471
  • Last Modified:

ODBC connection problem

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
Bergan2
Asked:
Bergan2
  • 3
  • 2
1 Solution
 
HainKurtSr. System AnalystCommented:
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
 
HainKurtSr. System AnalystCommented:
have a look at this article from MS

http://support.microsoft.com/kb/328306
0
 
Bergan2Author Commented:
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
 
Bergan2Author Commented:
I restarted the services on the SQL express 2005 and the problem is resolved.

Thanks.
0
 
Bergan2Author Commented:
Thanks for your help.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now