Solved

SQL Server Error

Posted on 2007-03-21
6
334 Views
Last Modified: 2012-06-27
when using MS acess we receive the following error:
Microsoft SQL Server Login
Connection failed:
sqlstate: '01000'
sql server error :10060
[microsoft][obdc sql server driver][tcp/ip sockets]connectionopen (connect()).
Connection failed:
sqlstate: '08001'
sql server error :17
[microsoft][obdc sql server driver][tcp/ip sockets]sql server does not exist or access denied.

I have:
--Checked the system dns config settings within odbc for the database applications the information is pulled from and tested the connections and they tested successfully.
--Checked registry
--Client network utility on server and all settings are correct.
--I am able to telnet the server using port 1433, so its not being blocked by the firewall.

Any suggestions on how to move forward????

Thanks in advance.
0
Comment
Question by:chipsexpert
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:lucas911
ID: 18766420
You can try these suggestions:

http://www.webservertalk.com/message92511.html
0
 
LVL 2

Author Comment

by:chipsexpert
ID: 18766521
Thanks. I am able to ping and do everything which was stated in the article.
Also, I am working with MS Windows Sever 2003 sp1
0
 
LVL 13

Expert Comment

by:lucas911
ID: 18766547
What about applying all the patches for SQL server itself?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 2

Author Comment

by:chipsexpert
ID: 18766576
Are there any other possible solution besides applying patches to the sql server?
0
 
LVL 13

Accepted Solution

by:
lucas911 earned 500 total points
ID: 18766694
0
 
LVL 9

Expert Comment

by:FixingStuff
ID: 18767853
Did you check the Client Network Utility on the *client* end?
Start Run, CLICONFG
Make sure TCP/IP is enabled
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

920 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

16 Experts available now in Live!

Get 1:1 Help Now