note 77436 added to ref.mssql

I tried all manner of things in order to cnnect to SQLExpress aka SQL Server 2005 and was just about to walk away and move across to MySQL when it just dawned on me that after following all of the instructions from numerous people I never restarted the Apache service. This meant that the new ntwdblib.dll was never called. I restarted the service and hey presto ... I can now connect to the SQL server. The items that I did were as follows: 1. Installed the SQLServer in mixed auth mode 2. Checked that the mssql.secure_connection = Off was present in the php.ini 3. Copied the ntwdblib.dll file into o WINDOWS\SYSTEM32 o program files\apache2\bin o php 4. Started the SQL Server Browser Service 5. Enabled all of the IPs in Protocols > TCP/IP 6. Restarted the following services: o Apache o SQL Service o SQL Browser Service This allowed me to connect with no problems using the following parameters within my mssql_connect call HOST=.\SQLEXPRESS USERNAME=sa PASSWORD=<MYPASS> ---- Server IP: 80.241.173.254 Probable Submitter: 84.92.176.187 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/77436 Del: integrated -- https://master.php.net/note/delete/77436/integrated Del: useless -- https://master.php.net/note/delete/77436/useless Del: bad code -- https://master.php.net/note/delete/77436/bad+code Del: spam -- https://master.php.net/note/delete/77436/spam Del: non-english -- https://master.php.net/note/delete/77436/non-english Del: in docs -- https://master.php.net/note/delete/77436/in+docs Del: other reasons-- https://master.php.net/note/delete/77436 Reject -- https://master.php.net/note/reject/77436 Search -- https://master.php.net/manage/user-notes.php