Help me with this error mssql_pconnect() unable to connect to server

Results 1 to 4 of 4
  1. #1
    Account Upgraded | Title Enabled! GMDeveloper1 is offline
    True MemberRank
    Mar 2013 Join Date
    301Posts

    Help me with this error mssql_pconnect() unable to connect to server

    Help me with this error mssql_pconnect() unable to connect to server
    hello any one can help me why i always got this error i install SQL Server 2005
    mssql_pconnect() unable to connect to server ? please help me how to fix the error . cant connect to name/SQLEXPRESS link to UserLogin and i already set it on ODBC on User DSN and System DSN still cant connect im using xampp for temporary please help . whats the problem with this one.


    Error :
    Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: mycomputer\SQLEXPRESS

    when i login mycomputer\SQLEXPRESS on SQL Server management studio it connects with sa and pass . please help. why it cant connect.


  2. #2
    Account Upgraded | Title Enabled! alan110 is offline
    True MemberRank
    Dec 2007 Join Date
    240Posts

    Re: Help me with this error mssql_pconnect() unable to connect to server

    Hi Developer.

    il try my best here. "mycomputer\SQLEXPRESS " mycomputer needs to be the name you gave the sql instance when you set it up.

    the "sa" needs to be the name you have nominated in your db, item and sqldaemon config files the pass needs to be the same as well.

    the name for "sa" has to be configured in security folder as a valid login and given the correct permissions.

    also you will need to go to the php folder in xampp and make sure the mssql.dll is enabled.

    you may also need to install this ntwdblib.dll. in the php folder and in apache folder.

    regards for now alan110

  3. #3
    Developer Terrified is offline
    True MemberRank
    Dec 2013 Join Date
    Six MountainsLocation
    229Posts

    Re: Help me with this error mssql_pconnect() unable to connect to server

    Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: mycomputer\SQLEXPRESS
    -first check if this is running in your sql browser.
    -check if the tcp/ip is enabled.

    if you can make the odbc then test it. create a php files then check if it is running like placing a code

    $myconn = mssql_pconnect('hstname','user','pass','db') or die(unable to connect sql);

    from there you can check if your computername\SQLEXPRESS is functioning. Use MSSQL 2012 its better and easier than 2005.
    -=Make sure everybody in the company has great opportunities, and that they feel they're having a meaningful impact.=-
    -- Larry Page

    Currently a freelance after a 6-year close-in contract.

  4. #4
    Newbie maqyot is offline
    MemberRank
    Jan 2020 Join Date
    4Posts

    Re: Help me with this error mssql_pconnect() unable to connect to server

    i know this is old, but this is my same problem with him,



Advertisement