Install Apache/PHP/FreeTDS on FC/RHEL to connect to MSSQL2000 on W2KS --------------------------------------------------------------------- 2005-04-21 This setup allows you (using the Apache/ADS auth doc in step 4) to authenticate users/groups in Microsoft ADS for web services running on Apache on Linux. It also allows you to have PHP applications on Linux access a Microsoft SQL Server 2000 and have a "trusted connection" between your PHP and MSSQL. This allows you to use domain users/groups to control access to and define roles in your MSSQL database. The idea is to prevent the need for permission tables and control user access to your database using ADS users and groups. 01. Install FC/RHEL, choose Web Server (Apache) and include PHP packages 02. Download freetds & php-mssql RPMs from http://phprpms.sourceforge.net/mssql 03. Make sure your versions of PHP match and install freetds & php-mssql RPMs 04. Configure Apache to authenticate to Microsoft ADS http://www.turnpike420.net/linux/Apache_ADS_AuthLDAP.txt Configure FreeTDS ----------------- (http://www.freetds.org) 05. vi /etc/freetds.conf Sample Entries ([Hostnameno] just means no domain login b/c you can't use [Hostname] twice, it can be whatever you want): #HOSTNAME for domain login [Hostname] host = hostname.example.com port = 1433 tds version = 8.0 try domain login = yes nt domain = EXAMPLE #HOSTNAME for server login [Hostnameno] host = hostname.example.com port 1433 tds version = 8.0 Configure PHP4 -------------- (http://www.php.net) 06. vi /etc/php.ini a. mssql.secure_connection = On 07. Write a test php page, for help: http://us2.php.net/mssql Sample: 08. Thank the phprpms developer!