SQL Server error 10061

Posted on 2006-04-05
Last Modified: 2009-09-30
Hello guys !!

I have a "server" that has a reporting tool called Artus and connect to a SQL Server 2000.
It has been working perfectly for more than 10 months until Monday.
Since then I'm receiving the following error:

Connection failed:
SQLState: '01000'
SQL Server Error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]connectionOpen(Connect()).
Connection failed:
SQLSTate: '08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

What can I do?
Question by:Mighty_Ed
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    1) check if the sql server is indeed started on the server
    2) check which service pack you have on the windows server installed (which version of windows?), and which service pack your sql server has (should be at least SP3)

    Author Comment

    yes it's started the rest of my users, myself and other servers are connected to it.

    The workstation I'm willing to reconnect to the server is XP PRO SP2

    The server I'm willing to reconnnect is NT 4.0

    AGAIN; everything was working perfectly. I think ity has something to do with daylight savings because in Mexico we changed on Sunday

    Author Comment

    Well I finally solved this out.
    For some reason the server was blocking the port and the session, I stopped the service, started it again and exactly when the service starts I started the session and everything worked out.

    Thanks anyway

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    754 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

    21 Experts available now in Live!

    Get 1:1 Help Now