PHP can't connect to SQL Server

Question

I have been thrown into the world of PHP, and I'm having a bit of an issue connecting to my SQL server. I'm using the following code to try to connect. When it hits the SQLsrv_connect command, it just seems to stop processing. No error, it just stops loading.

function testConnection()
{
    $returnable = "TEST";

    echo 'Current PHP version: ' . phpversion();
    $connectionInfo = array("Database"=>"MyDatabase", "UID"=>"MyLogin", "PWD"=>"MyPassword");
    $conn = sqlsrv_connect("MyServer",$connectionInfo);
    if ($conn) {
       echo "Connection Established.<br />";
    } else {
       echo "Something went wrong while connecting to MSSQL.<br />";
    }

     return $returnable;
}

Any idea on what I might be missing? I tried some very old syntax for version 5, and I got the same issue. I am trying to connect to sql server 2008.

Thanks

How do you connect to the database normally? Is it with Windows based authentication or do you use a username and password? — Niels
– Niels, Commented Jan 16, 2018 at 19:46
It just stops processing. any echoes before will be displayed, but if I try putting one after, it will not be displayed. — Limey
– Limey, Commented Jan 16, 2018 at 19:53

bliszka · Accepted Answer · 2018-01-16 20:44:19Z

1

First, check if you have installed the sql_srv extension for PHP. Probably this extension is not installed/loaded by you php.ini file.

For Windows

Download proper driver from SQL Driver for MSSQL extract and copy into you php installation directory. Then edit php.ini file and add in extensions path your extension. (For 99% you should copy NTS sql_srv version) also don't forget add sql_srv_pdo extension.

For Ubuntu/Linux You can try install sql_srv and pdo_sql_srv by pecl (if is installed) pecl install sqlsrv pdo_sqlsrv.

answered Jan 16, 2018 at 20:44

bliszka

687 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Limey Over a year ago

I did find this issue on my local machine, and was able to get it working (I have php 7.0). However, now I am trying it on my dev server, and the connection test works fine, however, the exact same code won't work.

Collectives™ on Stack Overflow

PHP can't connect to SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related