note 70918 deleted from function.mssql-connect by danbrown

Note Submitter: grv575 at hotmail dot com ---- 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...).