note 38143 deleted from function.mssql-connect by danbrown
| From: | danbrown@php.net | Date: | Sun, 07 Dec 2008 19:48:52 +0000 |
| Subject: | note 38143 deleted from function.mssql-connect by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147881@lists.php.net to get a copy of this message | ||
Note Submitter: jack at mvps dot removethis dot andthis dot org
----
I'm running PHP 4.3.3 on IIS on a Windows XP workstation and connecting to SQL Server 2000 on a
remote server.
I found that even though I had "SQL and Windows Authentication" selected, and even if I
was using the "sa" account, I wasn't able to connect to the database and I would
receive the message:
Warning: mssql_connect(): message: Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection. (severity 14) in {filename} on line {line number}
I discovered that NT Authentication was turned on in php.ini:
[MSSQL]
mssql.secure_connection = On
By switching this to Off, the user name and password credentials supplied in the function call work
correctly.