Environment: IIS6.0 PHP5 SQL Server2005
When SQL Server is installed, choose Hybrid login mode, windows and SQL Server authentication mode.
Steps:
1. First configure the PHP5 connection MS SQL Server as usual
PHP.ini inside Open extension=php_mssql.dll option (just remove the front; number)
Mssql.secure_connection = Off
2. Download the correct version of Ntwdblib.dll (2000.80.194.0)
3. Cover C:windowssystem32twdblib.dll
4. Overwrite Phptwdblib.dll (sometimes this step is not successful, the PHP depends on the Php5ts.dll in the System32 directory)
5. Run SQL Server Configuration Manager: SQL Server Config Manager, open protocol protocols
6. Allow Named pipes "Named Pipes" and "TCP/IP"
7. Right-click on "TCP/IP" to open the Property Properties tab "addresses"
8. Fill in the TCP dynamic port "TCP Ports" 1433 (after testing, in fact, can not be filled here)
9. Restart SQL Server, IIS, and PHP
10. Connect with the hostname port number, mssql_connect ("localhost,1433", "sa", ""); (I tried it, I didn't
http://www.bkjia.com/PHPjc/486168.html www.bkjia.com true http://www.bkjia.com/PHPjc/486168.html techarticle environment: IIS6.0 PHP5 SQL Server2005 SQL Server installation Select Hybrid login mode, windows and SQL Server authentication mode. Step: 1. First, according to the usual procedure to configure the PHP5 lian ...