Lsd_asp_iis7_01.png' alt='Iis 7 Download Big Files' title='Iis 7 Download Big Files' />Download previous releases of the Azure SDK for. NET. Microsoft Windows IT Pro Center. Get the inside scoop on the latest Windows 1. Register for live webcasts or join our Ask Microsoft Anything AMA sessions for exclusive access to Microsoft engineers, product specialists, and community experts. A Complete Guide to Installing My. SQL and PHP with IISOne of my latest projects was setting up Word. Press, the popular content management system, on a clients web server which was running Windows Server 2. Word. Press requires installations of My. SQL for the database back end and the PHP scripting language in order to serve up the Word. Press content. On a local Windows machine, Id probably just use a pre configured WAMP Windows, Apache, My. SQL, PHP stack package like Easy. PHP which is installed quickly and includes all the necessary components. A comprehensive Windows 10 resource for IT professionals. Find downloads, tools, technical documentation, best practices, and other learning resources to help upgrade. You cannot download more than 50 MB or upload large Files when the upload takes longer than 30 minutes using Web Client in Windows 7. Thats not quite an option in a professional environment, though. I was also working with Internet Information Services IIS 7. Apache so the process is a little more involved. In addition to installing the components, PHP must be be configured to work with My. Iis 7 Download Big Files' title='Iis 7 Download Big Files' />SQL so that Word. Press, which maintains all the site content in My. SQL, can access the database as needed. Having only previously done this in Linux with Apache as the web server, I had to do a little research. It was not painless, Word. Press is a little finicky on IIS Windows and I had to research my way past a a couple stubborn errors. For everyones benefit, I thought Id share what I learned here. Ive tested this process on both Windows Server 2. Pre requisites. By the time the process is finished you will probably need both the Visual C Redistributable for Visual Studio 2. Visual C Redistributable for Visual Studio 2. The My. SQL edition will automatically install the 2. PHP if you dont already have it. My. SQLThere are a couple options for installing My. SQL on Windows. It can be downloaded as ZIP file, unzipped into the directory of your choice and run via the command line or you can install it as a Windows service with all the bells and whistles. I personally like to run it as a service and let Windows manage things. Whatever option you choose, all the downloads are available from http dev. I chose the My. SQL Installer 5. Windows which installs everything. The installer is 3. My. SQL depending on your system. Theres also the option to choose a small file that will perform a web installation or the large file if youre not certain youll have a connection available. I chose the Custom setup type from the first option screen so I could choose which components I wanted on the machine. For this use, the server itself, My. SQL Workbench and Notifier, which alerts the user to any change in the servers status, was enough. I didnt specifically need Workbench for a Word. Press installation but it doesnt take up much room and might come in handy at some point. The My. SQL Installer allows for a custom installation so that you can manage the size of My. SQLs footprint on your system. If youre installing My. SQL Workbench, you might need to install the Microsoft  Visual C 2. Runtime in order to complete the installation. The Installer will notify you of this or any other failing requirements and give you the chance to fix them without stopping the installation routine. Amharic there. The Microsoft Visual C 2. Runtime is a pre requisite for My. SQL Workbench. The rest of the Installation wizard screens are pretty well self explanatory. Under Type and Networking, I chose Server Machine since this would actually be a web server and I went with the standard system account for the Windows service screen. After the installation finishes, it will offer to open My. SQL Workbench where you can ensure that youre able to login to your new database server. Another option is to open the My. SQL 5. 6 Command Line Prompt from the Start menu and type in the password that you set for the My. SQL root account. My. SQL can be managed either from My. SQL Workbench or from the My. SQL command line client. While youre here, you might as well create the My. SQL database for Word. Press to use. You can do this through My. SQL Workbench if youve installed it or through the My. SQL Command Line with the following commands CREATE DATABASE wordpress. CREATE USER wpuser IDENTIFIED BY lt password. GRANT ALL ON wordpress TO wpuser With these commands, you create a Word. Press database and set it as the default in your My. SQL session. Then you create an administrative user for Word. Press so youre not using the server root user and grant that user all privileges on the Word. Press database. You can use the user name and passwords of your choosing. Just be sure to store them in a safe place. If youre using the command line, type exit to leave My. SQL and then exit again to exit the command prompt. Article continues after ad. Marion Technical College in Ocala, Florida offers a variety of vocational and career programs, including Database Development and Programming. Find out more on our site at http www. PHPPHP doesnt have an installation routine but you will need to edit the configuration files. Id like to offer a big Thank You to How. To. Geek. com for providing the tutorial that got me started with this process. You can download the Windows PHP files from http windows. The non thread safe edition is required when working with IIS and I stuck with the 3. Im using the current stable version, 5. After youve downloaded the PHP files, unzip the package to the directory of your choice on your hard drive. Easy Flight Simulator Games. I chose c php to keep things simple. The package includes a php. This file holds keys and settings, many of which are commented out and can be uncommented to apply specific settings as needed. In your favorite text editor, uncomment the following keys in php. Set extensiondir to the ext folder in the path where you stored the PHP fies i. C PHPext. around 7. The last setting is a string value without quotes around it, i. AmericaNewYork. You can find a list of appropriate values at http php. In order for PHP to function with My. SQL, you will also  need to uncomment the following lines in the Windows Extensions section. The phpcurl. dll extension is to enable Word. Press to retrieve and display product news updates. Without it, youll see an error message on your desktop every time you log in. IISAfter youve setup PHP, youll need to configure IIS to work with PHP. First verify that the machine has been assigned the role of a web server and that CGI is installed as a service under IIS. On Windows Server, You can do this by opening the Server Manager not the IIS Manager and selecting Web Server IIS under Roles. If this option does not exist, right click on Roles under the Server Manager tree and add it. The server needs to be assigned the role of a Web Server so that IIS will be available. Be sure to select the CGI option under Application Development in the Add Roles wizard. If the web server is already installed but CGI does not show as installed under the Application Development group, you can add it by clicking on Add Role Services and selecting it. The CGI service is required for IIS to work with PHP. This service can be found under Application Development. The process is the same in Windows Server 2. Add Roles Wizard has gotten an overhaul. Windows Server 2. The CGI service is required under Windows Server 2. After the web server role and CGI service have been established, check under the Internet Information Services Manager for the Fast. CGI Settings option. This should be present if youre running IIS 7. If your running IIS 7, you might need to install the IIS 7 Administration Pack which can be downloaded from Microsoft. You will need to add the php cgi. IIS under the Fasts CGI settings.