linux server connect to windows mssql

Had difficulty getting ports setup up and testing whether drivers worked

Used freetds to act as driver with dblib

tested by using tsql -S [hostname] -U [username] -P [password]
where hostname was declared in /usr/local/etc/freetds.conf

[myserver1]
host = domain.name
port = 1433
tds version = 8.0

use version8.0 for mssql server 2008

Installing freetds was a challenge

http://pointbeing.net/weblog/2010/05/successful-microsoft-sql-server-support-for-php-on-linux.html
http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFLOCATION
http://howtogetitworking.com/2008/02/26/how-to-install-mssql-extension-for-php-on-unix/

http://docs.moodle.org/20/en/Installing_MSSQL_for_PHP

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply