note 96228 added to ref.mssql
| From: | mista-birdy | Date: | Tue, 16 Feb 2010 08:53:17 +0000 |
| Subject: | note 96228 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-165998@lists.php.net to get a copy of this message | ||
I'm using IIS 6.0, PHP 5.2 (issapi) and MSSQL.
I've had Problem to connect with PHP to MSSQL.
The Errormessage was that Loginname was incorrect.
My Solution is to set mssql.secure_connection = off
and create an MSSQL-Account (No Windows Authentification!) and connect to MSSQL Server. It works!
If you like to use Windows Authentification, you can use the Apache Service with your desired
Account and set mssql.secure_connection = on. Then you can use the mssql_connect() function without
user/pwd.
I don't know how this works with IIS 6.0 Server.
----
Server IP: 69.147.83.197
Probable Submitter: 62.2.178.3
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- https://master.php.net/note/edit/96228
Del: integrated -- https://master.php.net/note/delete/96228/integrated
Del: useless -- https://master.php.net/note/delete/96228/useless
Del: bad code -- https://master.php.net/note/delete/96228/bad+code
Del: spam -- https://master.php.net/note/delete/96228/spam
Del: non-english -- https://master.php.net/note/delete/96228/non-english
Del: in docs -- https://master.php.net/note/delete/96228/in+docs
Del: other reasons-- https://master.php.net/note/delete/96228
Reject -- https://master.php.net/note/reject/96228
Search -- https://master.php.net/manage/user-notes.php