note 70907 added to ref.mssql

The 3 major headaicks I had while setting up MS SQL 2005, php 5.1.6 (apache 2.2 server) on Vista RC1 and getting them to comunicate. TCP/IP and "Named Pipes Protocol" had to be enabled in the MS SQL Server. You do this in the Surface Area Configuration tool. MS SQL 2005 should be set to mix mode login. Unless you use NT authentication in php.ini. You can do this in duing install if you select advanced options. If it's already installed you will have to use the SQL management Studio (properties->securety). At first the php_mssql.dll didn't load properly (wan't showing up under phpinfo()) and gave no error message at startup, the cause of this was the ntwdblib.dll that came with php (273KB) replacing it with the one that came with MS SQL 2005 (269KB) fixed the issuse, incase you haven't installed MS SQL on your machine you can also find it on the net. ---- Server IP: 66.163.161.117 Probable Submitter: 80.163.6.219 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/70907 Del: integrated -- https://master.php.net/note/delete/70907/integrated Del: useless -- https://master.php.net/note/delete/70907/useless Del: bad code -- https://master.php.net/note/delete/70907/bad+code Del: spam -- https://master.php.net/note/delete/70907/spam Del: non-english -- https://master.php.net/note/delete/70907/non-english Del: in docs -- https://master.php.net/note/delete/70907/in+docs Del: other reasons-- https://master.php.net/note/delete/70907 Reject -- https://master.php.net/note/reject/70907 Search -- https://master.php.net/manage/user-notes.php