Post reply

Sql connection error when connecting with broadband

  • December 2, 2011 at 1:54 am

    #148844

    When we connect database locally it works properly but when we use broadband or isdn then error occured:

    TCP Provider: No Connection could be made because the target machine actively refused it;

  • December 2, 2011 at 2:08 am

    #1415751

    ruchikakkar2005 (12/2/2011)

    When we connect database locally it works properly but when we use broadband or isdn then error occured:

    TCP Provider: No Connection could be made because the target machine actively refused it;

    Is SQL Server listening on default "1433" port ? Is SQL Server is behind the firewall ?

    If yes, Are you able to successfully telnet the port 1433 from your client machine ? If you are not able to telnet then you need to open the port 1433 for your client machine IP.

    Sujeet Singh

  • December 2, 2011 at 3:20 am

    #1415778

    I didn't getting ur point Please clearify ur Question

  • December 2, 2011 at 4:01 am

    #1415787

    ruchikakkar2005 (12/2/2011)

    I didn't getting ur point Please clearify ur Question

    No problem, what I mean to say is:

    1. Go to your client machine (the machine from where you are trying to connect the SQL Server).

    2. Open CMD and type:

    telnet <SQL Server IP addres here> 1433

    3. Press enter

    Do you get any error after that ? Post here the result.

    P.S. I assume that your SQL Server is running on default port (1433). You can check this information in SQL Server error log.

    Sujeet Singh

  • December 14, 2011 at 12:00 am

    #1421026

    Thanks.It Works..........

  • December 14, 2011 at 12:18 am

    #1421038

    Glad to hear this :-). Well, you replied quite early though 😉

    Sujeet Singh

Viewing 6 posts - 1 through 5 (of 5 total)

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