locked
SQL 2000: Remote connection is deny : Error 10061 RRS feed

  • Question

  • Hi ALL

    I have problem on my  SQL 2000 server. Sometime program try to connect to SQL and get error 10061.

    And also the SQL agent jobs are all skipped during that time. however in the SQL Error log and SQL agent job log, there are no specific log

    to show any problem about SQL.

    Any other trace to trace for the problem.

    • Changed type Tom Phillips Wednesday, March 27, 2013 7:19 PM
    Tuesday, March 26, 2013 2:42 AM

Answers

  • http://www.c-sharpcorner.com/uploadfile/dhananjaycoder/microsoft-sql-server-error-10061/

    Hope this helps.!!!!!!


    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Tuesday, March 26, 2013 3:10 PM
  • Hello,

    The following blog id about troubleshooting SQL Server connectivity issue, please refer to:
    http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

    As for the Agent job, please verify the SQL Server Agent is running.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Thursday, March 28, 2013 10:38 AM
  • Hello!

    Try to read this article:

    http://blogs.msdn.com/b/spike/archive/2008/11/07/sql-server-error-10060-sql-server-error-10061.aspx

    This is for SQL 2005 but i believe it can helps you a lot because is the same issue!

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Thursday, March 28, 2013 11:32 AM

All replies

  • http://www.c-sharpcorner.com/uploadfile/dhananjaycoder/microsoft-sql-server-error-10061/

    Hope this helps.!!!!!!


    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Tuesday, March 26, 2013 3:10 PM
  • Hello,

    The following blog id about troubleshooting SQL Server connectivity issue, please refer to:
    http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

    As for the Agent job, please verify the SQL Server Agent is running.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Thursday, March 28, 2013 10:38 AM
  • Hello!

    Try to read this article:

    http://blogs.msdn.com/b/spike/archive/2008/11/07/sql-server-error-10060-sql-server-error-10061.aspx

    This is for SQL 2005 but i believe it can helps you a lot because is the same issue!

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Proposed as answer by Fanny Liu Monday, April 1, 2013 10:25 AM
    • Marked as answer by Fanny Liu Tuesday, April 2, 2013 10:25 AM
    Thursday, March 28, 2013 11:32 AM