none
Connecting to SQL server 2008 r2 remotely (connection refused)

    Question

  • Hi guys i'm  having trouble connecting to sql server 2008 r2 remotely. The server is running on window 7 laptop.

    The WAN is the problem, I can connect to the server fine by using LAN. In sql server management studio i used following detials to connect via LAN, for WAN i have just replaced the ip obtained by www.whatismyip.com 

    ServerType: DatabaseEngine

    Server name: 192.168.1.22,1433\mssqlserver

    With sql authentication.

    This works fine, but connection via WAN is the problem i get following error when connection via WAN

    (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (.Net SqlClient Data Provider)

    I have the followings ticked :)

    • firewall is off on both machines client and server both are window 7
    • laptops tcp/ip is enabled in sql server configuration manager Service
    • port 1433 is forwarded from my rourter to 192.168.1.22
    • browser is running

    Cheers guys some help would be appreciated 

     
    Tuesday, May 08, 2012 5:37 AM

Answers

All replies