64-bit sqlserver2005 + iis7.5 + php environment in windows2008

The program finally runs successfully, listing the steps and encountered problems:

1. IIS installation method
Open "service manager", choose "role"> "add Role", select "IIS", and select "application development", because the next step is to use CGI of PHP, and the next step is to complete.

2. SQLServer2005 installation method
After testing, x64 or x86 versions can be installed normally without any problems or impact on connection usage.

3. Installation of SQL Server Management Studio Express
Download SSMSE of x64. I encountered a 29506 error during the installation process and cannot install it. Solution:
Create a text file, change the extension to cmd, edit, and write the code:
1
Msiexec/I D: \ SQLServer2005_SSMSEE_x64.msi
Replace the file path in the code;
Right-click the cmd file and select "run as administrator ";
Problem KO.

4. Added PHP support for IIS
1) Microsoft provides PHPManagerForIIS directly. Download and install PHPManagerForIIS, which is quick and convenient. Remember to install x64;
2) Download PHP and select your own version. sqlsrv driver problems may occur after different versions, which will be discussed later;
3) decompress PHP and configure php. ini;
Timezone and extension do not affect php execution, but the parameters are determined based on the specific project;
I encountered an upload error because the upload failed. upload_tmp_dir = "C: \ Windows \ Temp" is invalid as the temporary directory for uploading. Only one directory can be set manually, and grant the write permission to Everyone;
4) locate PHPManager in IIS and open "register new php version.exe". Select the php-cgi.exe to be decompressed;

5. PHP requires the support of Microsoft Visual C ++ 2008 Redistributable. Otherwise, the FastCgi error will occur during php execution and I will be stuck for a long time;
Note that you need to install vcredist_x86 instead of x64, because php is 32-bit. Otherwise, an error will be reported and the system will be ruined...
Link: vcredist

6. Install the sqlsrv driver so that PHP can connect to SQLServer2005;
Both 2.0 and 3.0 drivers can be used for testing, while 2.0 must be combined with SQL Server 2008 Native Client, while 3.0 must be combined with SQL Server 2012 Native Client.
Http://www.microsoft.com/en-us/download/details.aspx? Id = 20098
Note: The numbers 5.2, 53, and 54 in the DLL file represent the PHP versions 5.3, 5.4, and, respectively. The ETS and ts represent blocking and non-blocking. For iis, use vc9. For apache, use vc6, please refer to your php version to select the corresponding two dll and write it into php. extension of ini;

7. Install SQL Server 2012 Native Client or SQL Server 2008 Native Client. The installation depends on the method you selected in the previous step.

I only listed the problems I encountered and hoped that the configuration would be smoother next time.