Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    6

    Exclamation Unanswered: connect SQL Server from Remote PC on another network.

    Hi All,

    I need a help on SQL Server Remote Connection Issue.
    I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which are in the same network can connect connect to my system and application runs successfully.But the clients outside the network cannot connect to my SQL Server.
    I have enabled TCP/IP, Named Pipes to allow remote connections on my computer.I have also allowed my sqlserver and browser to pass via firewall on Windows 7.
    This problem seems to be with IP Addresses. I guess I dont have public Unique IP assigned. I connect to Internet using "Broadband WAN Miniport PPPOE".In local network I can ping my system from client machine.Client machine which is in different network i cant ping to my machine... Why..?
    On my system IPCONFIG /ALL lists the following :
    ************************************************** **************************
    Windows IP Configuration

    Host Name . . . . . . . . . . . . : TonseTonyServer-HP
    Primary Dns Suffix . . . . . . . :
    Node Type . . . . . . . . . . . . : Mixed
    IP Routing Enabled. . . . . . . . : No
    WINS Proxy Enabled. . . . . . . . : No
    DNS Suffix Search List. . . . . . : mshome.net

    PPP adapter Broadband Connection:

    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : Broadband Connection
    Physical Address. . . . . . . . . :
    DHCP Enabled. . . . . . . . . . . : No
    Autoconfiguration Enabled . . . . : Yes
    IPv4 Address. . . . . . . . . . . : 192.168.150.234(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.255
    Default Gateway . . . . . . . . . : 0.0.0.0
    DNS Servers . . . . . . . . . . . : 192.168.150.1
    192.168.100.1
    NetBIOS over Tcpip. . . . . . . . : Disabled

    Wireless LAN adapter Wireless Network Connection:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : Broadcom 4313 802.11b/g/n
    Physical Address. . . . . . . . . : CC-52-AF-96-8F-C1
    DHCP Enabled. . . . . . . . . . . : Yes
    Autoconfiguration Enabled . . . . : Yes

    Ethernet adapter Local Area Connection:

    Connection-specific DNS Suffix . : mshome.net
    Description . . . . . . . . . . . : Realtek PCIe FE Family Controller
    Physical Address. . . . . . . . . : 2C-27-D7-CC-2E-7D
    DHCP Enabled. . . . . . . . . . . : Yes
    Autoconfiguration Enabled . . . . : Yes
    Link-local IPv6 Address . . . . . : fe80::d581:f5e:b4d0:c1aa%13(Preferred)
    IPv4 Address. . . . . . . . . . . : 192.168.0.12(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Lease Obtained. . . . . . . . . . : 27 November 2011 10:40:36
    Lease Expires . . . . . . . . . . : 06 December 2011 10:17:24
    Default Gateway . . . . . . . . . : 192.168.0.1
    DHCP Server . . . . . . . . . . . : 192.168.0.1
    DHCPv6 IAID . . . . . . . . . . . : 288106455
    DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-15-51-8B-1E-2C-27-D7-CC-2E-7D
    DNS Servers . . . . . . . . . . . : 192.168.0.1
    NetBIOS over Tcpip. . . . . . . . : Enabled
    ************************************************** *************************

    I guess my IP Address is 192.168.0.12 and if i use to ping this address from a remote computer that is on another network, packets are lost.If i use to ping from a computer within local network, ping works. I also tried OSQL -L/SQLCMD -L from a computer that is outside the local network, it says no servers.Within the network it lists my SQL server.
    How to connect from a computer that is outside the local network? I dont much about networking and all, Please help me..

  2. #2
    Join Date
    May 2008
    Posts
    97
    I use Putty with Port forwarding to localhost - it is port 1403 (just saving you time). Then you will be able to find your server in MSSQL browser connection to localhost

  3. #3
    Join Date
    Nov 2011
    Posts
    6

    Exclamation How to configure Putty?

    Hi Thanks for your reply... Can you let me know how to configure putty on remote computer(diff network) to able to connect my pc(SQL Server)???
    And wat is this PUtty?why we use it?

Tags for this Thread

Posting Permissions

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