note 48247 added to function.mssql-connect

From: Date: Thu, 16 Dec 2004 14:17:52 +0000
Subject: note 48247 added to function.mssql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-81864@lists.php.net to get a copy of this message
I am yet another person who had problems getting php[5] to play nicely with SQL Server 2000 [MSDE] on WinXP SP2 w/IIS. Following the notes on this page from previous users did get me closer, but I still could not connect. I was getting an error that said, in essence: "MACHINENAME\IUSR_MACHINENAME" could not connect to the server. Through some painstaking googeling I was able to resolve the problem by following this MSKB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;319930 It seems that my default install of MSDE did NOT "Enable Mixed Mode Authentication" which is required for this kind of connection. To make matters worse, the only way to change this with MSDE is to go mucking with the registry (which always freaks me out a bit). The above article explains how to do this. ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+48247 Delete -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48247&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+48247&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#81864) next »