Post reply

Remote Connection 2008 R2 not allowed

  • November 25, 2010 at 11:54 pm

    #241745

    Hi,

    I've got a SQL Server installed on my home PC, I've got a private application built in .net that I want my friend to use. It will connect to my SQL Server. It's a 2008R2 version

    Here is my connection string

    Public ConnectString As String = "Data Source=106.71.140.121, 1434;Network Library=DBMSSOCN;Initial Catalog=UserTable; User=AppUser; Password=123;"

    I've got port forwarding turned on to my machine 192.168.1.2 and have allowed remote connection. I also believe i've unblocked this in the firewall but it WILL not allow me to connect.

    Why?

  • November 26, 2010 at 12:38 am

    #1255710

    Be sure that your TCP is enabled in both side, you and your friend's SQL Server, enabling TCP will allow you to use remote connection!

    However be sure that you have started also the SQL Browser, most of the cases this service is disabled (it depends during the SQL Server installation), and you need to enable it and to start it!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • November 26, 2010 at 12:43 am

    #1255712

    Each end? my friend is connecting to my SQL Server.

    I've gone into the SQL Server Config App... which one should be enabled? all 4 are

  • November 26, 2010 at 1:00 am

    #1255718

    Take a look here http://is.gd/hO85W for you problem, follow the steps and tell us if you find the solution!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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

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