Linux to SQL Connection

Alan Taylor
Alan Taylor used Ask the Experts™
on
We have a Debian 7 Linux Server that we would like to connect to a Windows Server 2016 running SAGE 200 with SQL Server 2016 we have the management studio tools installed as well.  We have created a basic php script to allow the linux box access into the SAGE data tables but the linux box cannot connect to the SAGE Server at all.  The firewall is disabled on the windows server at present but we are still unable to connect.  Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
nociSoftware Engineer
Distinguished Expert 2018

Commented:
There are MSSQL drivers for PHP:  please check this one.
https://secure.php.net/manual/en/book.mssql.php
At least for MSSQL 2000, 2005, 2008

FreeTDS might be an option as well, described here.
https://coderwall.com/p/21uxeq/connecting-to-a-mssql-server-database-with-php-on-ubuntu-debian
This information from Microsoft regarding PHP and SQL server may also prove useful

https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-driver-for-sql-server?view=sql-server-2017
David FavorFractional CTO
Distinguished Expert 2018

Commented:
Couple of suggestions to keep your life simple, if possible...

1) Change over to running Ubuntu Bionic (LTS w/5 year support).

2) Setup to use the latest stable PPAs, so you end up running latest LAMP Stack code... as of today, versions are...

Kernel-4.15.0.23
Apache-2.4.34.1
MariaDB-10.3.8
PHP-7.2.9.1
OpenSSL-1.1.0h

Open in new window


If you start with latest stable code, you'll avoid dealing with bugs which have already been fixed.
ICT Manager
Commented:
Thank you all very much for the assistance but we have now resolved the issue.  

Sometimes you can't legislate for not receiving the correct information regarding credentials required for accessing the SQL databases!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial