locked
A network-related or instance-specific error occurred while establishing a connection to SQL Server. RRS feed

  • Question

  • Can you guys give me some leads to resolve below error, can we have to enable SQL Browsing Service ?

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) ---> System.ComponentModel.Win32Exception (0x80004005): The remote computer refused the network connection.

    Tuesday, February 18, 2020 6:07 AM

All replies

  • See MS Support: Solving Connectivity errors to SQL Server

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, February 18, 2020 6:19 AM
  • Hi Ketan Rajput,

    >Can you guys give me some leads to resolve below error, can we have to enable SQL Browsing Service ?

    1.Please make sure the SQL Server Service is running;

    2. If it is one named instance, make sure SQL Server browser service is running;

    3. Make sure SQL Server is configured to allow remote connections;

    4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports;

    5. Test server connectivity with PING from the client machine;

    6. Test port connectivity using TELNET or PowerShell to the server and port (from step 4) from the client machine;

    7. Check firewall settings if step 5 or 6 connectivity test fails.

    Please reference this : resolving-could-not-open-a-connection-to-sql-server-errors,troubleshoot-connecting-to-the-sql-server-database-engine

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, February 19, 2020 1:39 AM
  • Hi Ketan Rajput,

    Do you solve the issue?

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, February 21, 2020 7:48 AM