Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    Unanswered: can not connect remotely


    We have a windows SBS 2003 SP2 machine, which has a public IP address. SQL server 2005 is installed on this machine. This machine also has a Visual Studio Source Safe (VSS) installed. We need to access this so we configured the VPN (Routing and Remote Access) on it. We can connect remotely to this server through the VPN and access the VSS. Please note that VPN (Routing and Remote Access) is not blocking anything, while configuring a VPN server, an option appears with a check box which says:

    "Enable security on the selected interface by setting up static packet filters"

    I did not check (select) it.

    Now we want to access the SQL server remotely. So we enabled remote connections for SQL Server 2005 and also enabled the SQL Server Browser service. (How to configure SQL Server 2005 to allow remote connections

    Since VPN (Routing and Remote Access) is configured on this server the default firewall is disabled. So there is no need to create an exception for SQL Server 2005 in Windows Firewall.

    I can ping this server from a remote machine on its public IP. But when we connect to it ( an error occurs:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

    Please let me know how to fix it.


  2. #2
    Join Date
    Aug 2008
    Please check SQL server network utility for the port number configured and go to SQL server client network utility for the same server and create an alias with appropriate Port number . Try connecting the same

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts