note 48247 added to function.mssql-connect
| From: | bartlewis at gmail dot com | 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