note 92564 added to function.mssql-connect

For my setup (Windows Server 2003, IIS 6, PHP 5.2.6, SQL Server 2005 Enterprise) the key to getting a successful connection using mssql_connect was changing PHP from ISAPI mode to FastCGI mode. 1) I downloaded and installed FastCGI for IIS 6 from Microsoft http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1521 2) I modified my PHP install so it runs in FastCGI mode. 3) Opened fcgiext.ini and added this to the end. [Types] php=PHP [PHP] ExePath=c:\PHP\php-cgi.exe InstanceMaxRequests=10000 EnvironmentVars=PHP_FCGI_MAX_REQUESTS:10000 4) I added cgi.force_redirect=0 to the “; Default timeout for socket based streams (seconds)” section of PHP.ini 5) I made sure my SQL database was set to Windows authentication mode and I also switched mssql.secure_connection in php.ini to on. 6) Created an SQL login for NT AUTHORITY\NETWORK SERVICE and gave it the appropriate permissions to my database. 7) Rebooted the server ---- Server IP: 208.69.120.35 Probable Submitter: 65.220.31.241 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/92564 Del: integrated -- https://master.php.net/note/delete/92564/integrated Del: useless -- https://master.php.net/note/delete/92564/useless Del: bad code -- https://master.php.net/note/delete/92564/bad+code Del: spam -- https://master.php.net/note/delete/92564/spam Del: non-english -- https://master.php.net/note/delete/92564/non-english Del: in docs -- https://master.php.net/note/delete/92564/in+docs Del: other reasons-- https://master.php.net/note/delete/92564 Reject -- https://master.php.net/note/reject/92564 Search -- https://master.php.net/manage/user-notes.php