Solved

SQL Server Error

Posted on 2007-03-21
6
341 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

617 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