note 47493 added to function.mssql-connect

If you're having trouble getting PHP to connect to a SQL 2000 Server (the MSDE, specifically), try running the Server Network Client usually located at C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe Disable all protocols but Named Pipes. Then Apply your changes, click OK, and restart the SQL service with these commands at a command prompt: net stop mssqlserver [if it says the agent will stop too, let it happen] net start mssqlserver net start sqlserveragent That fixed it all for me. Also note that named pipes has a huge performance difference against TCP/IP. Named pipes are a tremendous amount faster. I have been working on this for two days now and I hope someone else stumbles across my solution! ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+47493 Delete -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+47493&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+47493&report=yes Search -- http://master.php.net/manage/user-notes.php