1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Plesk + PHP + MSSQL (REMOTE)

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by DorianW, Oct 26, 2010.

  1. DorianW

    DorianW Guest

    0
     
    Hello,
    I got a tiny problem with my plesk control panel, or better, it's modules. To be more specific the PHP of my Plesk Version (9.3) does not allow me to connect to a MSSQL server on another dedicated server. The ports on the other server are open and the mssql server is running, I can also connect to the MSSQL server using the Microsoft Management Studio or for testing purposes xampp. Only plesk does not allow to connect to my MSSQL Server.
    Here's the php error:
    Code:
    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: ***.**.**.*** in C:\inetpub\vhosts\{MY_DOMAIN}\httpdocs\moe\test\pages\register.php on line 21
    I just censored the domain and the ip address of the other dedicated server to avoid advertisement.

    Here's what I already tried to resolve this problem:
    - Updated the ntwdblib.dll to a 100%ly working one
    - Increased to timeout of mssql connections and queries
    - Checked if the mssql extension is loaded (It is!)
    - Tried other mssql servers (Didn't work)

    I also tried to use the support of my dedicated since they provided the plesk panel and they also don't know what the problem is but they are also trying to help me. I hope you can help me to fix this problem.

    sincerly,
    Dorian Weidler
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,539
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
  3. DorianW

    DorianW Guest

    0
     
    I can't really tell you how hard I could thank you now.
    It's working. :)
    THANK YOU =D
     
Loading...