Solved

SQL Server Error

Posted on 2007-03-21
6
336 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Learn about cloud computing and its benefits for small business owners.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

773 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