Linux to SQL Connection

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?
Alan TaylorICT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nociSoftware EngineerCommented:
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
0
kenfcampCommented:
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
0
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
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.
0
Alan TaylorICT ManagerAuthor 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!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.