// /usr/local/etc/freetds.conf

[global]
# TDS protocol version
tds version = 4.2
text size = 64512

[MSSQL2000]
host = XX.XX.XX.XX
port = 1433
tds version = 8.0

 

 

test connection with php

 

$dbhandle=mssql_connect(& quot;MSSQL2000",&nbs p; "username",&nbs p; "password")
or die("Couldn't connect to SQL Server on $myServer");