Problem connecting from PHP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • thiago777
    New Member
    • May 2007
    • 89

    Problem connecting from PHP

    Strangely enough, I can connect from a another computer in the network but not from the MSSQL server itself.

    Like this it works:

    PC1 apache/php (eg.192.168.100 .3) to:

    PC2 MSSQLSERVER(eg. 192.168.100.240 )

    with this configuration:

    $server = "192.168.100.24 0,3730";
    $user = "sa";
    $passwd = "mypass";
    $conn = mssql_connect($ server, $user, $passwd);

    But like this not:

    PC2 apache/php (192.168.100.24 0)
    PC2 MSSQLServer(192 .168.100.240 -> the same pc)

    with this configuration:

    $server = "127.0.0.1,3730 ";
    $user = "sa";
    $passwd = "mypass";
    $conn = mssql_connect($ server, $user, $passwd);

    Any clues?
    thnks
  • thiago777
    New Member
    • May 2007
    • 89

    #2
    Originally posted by thiago777
    Strangely enough, I can connect from a another computer in the network but not from the MSSQL server itself.

    Like this it works:

    PC1 apache/php (eg.192.168.100 .3) to:

    PC2 MSSQLSERVER(eg. 192.168.100.240 )

    with this configuration:

    $server = "192.168.100.24 0,3730";
    $user = "sa";
    $passwd = "mypass";
    $conn = mssql_connect($ server, $user, $passwd);

    But like this not:

    PC2 apache/php (192.168.100.24 0)
    PC2 MSSQLServer(192 .168.100.240 -> the same pc)

    with this configuration:

    $server = "127.0.0.1,3730 ";
    $user = "sa";
    $passwd = "mypass";
    $conn = mssql_connect($ server, $user, $passwd);

    Any clues?
    thnks
    I have no idea why this happens.. just as a info here is my config:

    MSSQL Server 2005 Express with Management Studio
    Default settings, user "sa" active from installation.

    if anybody have any idea please post! thnks

    Comment

    Working...