note 77150 added to function.mssql-connect

I had lots of issues with trying to get SQL Server '05 (NOT Express) to work with PHP 5.1.2 on Windows Server '03 SP2 running IIS 6. This is what finally worked: - Uncomment the php_mssql.dll line in php.ini - Replace the ntwdblib.dll file in /php/ext/ with the (smaller) downloadable file from webzila.com - Set SQL Server to mix-mode authentication ("Windows and SQL Server Auth") - Create IUSR_<computer_name> account in SQL Server using Windows authentication - Grant read/write access to the IUSR_<computer_name> in SQL Server - Create SQL auth account using SQL authentication - Grant read/write access to the SQL auth account in SQL Server - Restart the system I'd imagine that creating a way for IUSR to get into the SQL Server is NOT a good idea, but this is the only way I could get it to work. Hopefully, a future update to SQL Server will fix this. ---- Server IP: 209.41.74.194 Probable Submitter: 166.89.16.40 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/77150 Del: integrated -- https://master.php.net/note/delete/77150/integrated Del: useless -- https://master.php.net/note/delete/77150/useless Del: bad code -- https://master.php.net/note/delete/77150/bad+code Del: spam -- https://master.php.net/note/delete/77150/spam Del: non-english -- https://master.php.net/note/delete/77150/non-english Del: in docs -- https://master.php.net/note/delete/77150/in+docs Del: other reasons-- https://master.php.net/note/delete/77150 Reject -- https://master.php.net/note/reject/77150 Search -- https://master.php.net/manage/user-notes.php