Solved

SQL Server Error

Posted on 2007-03-21
6
333 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

747 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

13 Experts available now in Live!

Get 1:1 Help Now