Connecting SQL Server from PHP 7.4 / Ubuntu 20

Question

I am having trouble in Connecting to SQL Server remotely from PHP/Ubuntu 20.

Currently My PHP version is PHP7.4.I used this document to install the ODBC Driver

https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#installing-on-ubuntu (I have replaced the php version to 7.4 wherever it was 8.0).

Restarted the server and checked PHP Info. Seems its installed check screenshot

Now I am trying to connect to SQL Server. The SQL Server Access was given in IP, Username and Password. I am able to connect to database from HeidiSQL tool.

When I connect through PHP Code:

$conn = new PDO("sqlsrv:Server=". $serverName .";Database=". $databaseName, $uid, $pwd);

or

$serverName = "xxx.xxx.xxx.xxx";
$connectionOptions = array(
    "database" => "<mydbname>",
    "uid" => "<dbusername>",
    "pwd" => "<dbpass>"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

both given me error:

SQLSTATE: 08001
Code: 10054
Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746

Can anyone help in I don't know what I should follow. Is something I need to check on installation side, I mean on Ubuntu server or I should ask to SQL Server provider if they need to do something on their end.

Since it's a remote server, and possibly sitting behind a firewall, can you telnet to the server on tcp/1433? — AlwaysLearning
– AlwaysLearning, Commented Aug 31, 2021 at 4:10
make sure you follow learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/… Very easy to miss that little block in the guide — Erik
– Erik, Commented Aug 31, 2021 at 11:23

Sanjay Goswami · Accepted Answer · 2021-10-21 12:26:29Z

1

Its too late. Anyway I am answering my own question for someone who face same issue again. I have resolved this by installing an OpenSSL on the server.

Follow these steps for installation

https://help.dreamhost.com/hc/en-us/articles/360001435926-Installing-OpenSSL-locally-under-your-username

answered Oct 21, 2021 at 12:26

Sanjay Goswami

8762 gold badges21 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Connecting SQL Server from PHP 7.4 / Ubuntu 20

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related