note 70918 added to function.mssql-connect
| From: | grv575 at hotmail dot com | Date: | Sat, 04 Nov 2006 03:41:42 +0000 |
| Subject: | note 70918 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-119359@lists.php.net to get a copy of this message | ||
Getting IIS working with SQL Server and PHP:
1. Put the updated ntwdblib.dll (version 8.00.194) in your C:\php5 directory (which should be in
your PATH environment variable)
2. Set windows environment variable PHPRC=c:\php5
3. In php.ini: uncomment the 'extension=php_mssql' line and set the extension dir:
extension_dir = "c:\php5\ext"
4. Under windows folder options uncheck the use simple file sharing checkbox
5. Make sure NTFS permissions are set properly for your web files under C:\Inetput\wwwroot for
anonymous web access: IUSR_<COMPUTERNAME> (and IWAM_<COMPUTERNAME> if using the php CGI
exe instead of the ISAPI extension under IIS).
6. Enable anonymous web access under IIS Directory Security
7. Use SQL Server and Windows Authentication mode for SQL Server (then create an SQL Server Login
using SQL Authentication and a User mapping to that Login with db_reader role membership)
Note that using fast_cgi and getting "No input file specified." can be solved by giving
permission to IWAM_<COMPUTERNAME>, since it must launch a CGI process to render the file (bad
generic error message...).
----
Server IP: 216.194.113.175
Probable Submitter: 68.81.130.211
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/70918
Del: integrated -- https://master.php.net/note/delete/70918/integrated
Del: useless -- https://master.php.net/note/delete/70918/useless
Del: bad code -- https://master.php.net/note/delete/70918/bad+code
Del: spam -- https://master.php.net/note/delete/70918/spam
Del: non-english -- https://master.php.net/note/delete/70918/non-english
Del: in docs -- https://master.php.net/note/delete/70918/in+docs
Del: other reasons-- https://master.php.net/note/delete/70918
Reject -- https://master.php.net/note/reject/70918
Search -- https://master.php.net/manage/user-notes.php