note 57880 added to function.mssql-connect
| From: | mckoin at example dot com | Date: | Tue, 18 Oct 2005 03:58:26 +0000 |
| Subject: | note 57880 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-97129@lists.php.net to get a copy of this message | ||
If you use PHP on Windows with Apache as a web server, you may get problems with authentication to
MS SQL Server even when you supply all valid credentials.
Check your php.ini file:
; Use NT authentication when connecting to the server
mssql.secure_connection = On
If you have secure_connection = On, make sure that you provide valid credentials in the properties
for Apache service in the System Services box. Then you should not send DB username and password
from your script to MSSQL Server.
If you want to use specific credentials from a PHP script, then set mssql.secure_connection = Off in
your php.ini
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+57880
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=non-english
Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes&reason=already+in+docs
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+57880&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+57880&report=yes
Search -- http://master.php.net/manage/user-notes.php