I am not able to connect to sql server database engine from my machine to server having different networks.

  • TITLE: Connect to Server

    ------------------------------

    Cannot connect to server.trainingcloudz.com.

    ------------------------------

    ADDITIONAL INFORMATION:

    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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

  • Start by making sure you can ping the SQL Server.

    If you can ping it, check to make sure the SQL Server service is running.

    If it is, check to make sure the instance is configured to listen for TCP connections (SQL Express by default does not)

    If it is, check to make sure that the local firewalls are not dropping the communication. This applies to both client and server.

  • If you can ping the server from your machine then probably it will not be a firewall issue. Also try to access through IP and make sure that server is configured on default port. In case of customized port number also include the port number in connection string.

    DBDigger Microsoft Data Platform Consultancy.

  • AShehzad (11/25/2013)


    If you can ping the server from your machine then probably it will not be a firewall issue.

    Correct, ICMP traffic is the first traffic a firewall usually blocks. If you can ping the server you likely have no firewall in place unless your admins explicitly opened the firewall for ICMP (highly unlikely 😉 ).

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply