Installing SQL Server 2005 Express Edition

Microsoft SQL Server 2005 Express Edition is the free, easy-to use, lightweight version of SQL Version 2005. Integrated with Microsoft Visual Studio 2005, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, offer enhanced storage security, and are fast to deploy. SQL Server Express is free to redistribute and can be seamlessly upgraded to more sophisticated versions of SQL Server.

Download the following from the Microsoft homepage and save in C:\Program Files.

The SQL Server 2005 Express will NOT install without having the .NET v2.0 installed in your pc. Make sure you installed the .NET v2.0 prior to proceeding to SQL Server 2005 Express.

Install first the Microsoft SQL Server Configuration Tools by going to the saved directory of downloaded installation files. Double click the SQLEXPR.EXE.

3.	Click the checkbox to accept the End User License Agreement then click Next.

4.	Click Install. Then the SQL Pre-requisite components will be installed.

6.	Then the Microsoft Server Installation Wizard appears. Click Next to continue.

7.	Wait until the System Configuration Checking gets completed. Then click Next to continue.

8.	Click Browse then map the directory for your SQL Express to be installed in C:\Programs. Then notice that the Client Components is marked X.

9.	Click on that then select Entire feature will be installed on local hard drive. Then the X mark will also disappear in the Connectivity Components and Software Development Kit. Click Next to proceed.

10.	Enter the Name and Company for Registration Information then click Next to proceed.

11.

Then the Authentication Mode page proceeds. Select Mixed Mode (SQL and Windows Authentication), though it is possible to choose ONLY Windows, a lot of web hosts do NOT support it. Therefore it is a MUST to choose both. Then supply a STRONG password (alphanumeric characters) on both box, take note of this password. Click Next to proceed.

12.	For the Error and Usage Report Settings page, UNCHECK the two (2) boxes so it would not send any Error and Feature Usage Report to Microsoft or your corporate error reporting server. Click Next to proceed.

16.	Check if it is successfully installed by going to Start>Programs> Microsoft SQL Server 2005 and you will see the Configuration Tools containing the three (3) components: SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Surface Area Configuration.

17.	We just finished installing the SQL Server Configuration Tools. Let’s go back to the directory where we saved the 2 downloaded files. Then double click this time the SQL Server2005_SSMSEE.msi to install SQL Server Management Studio Express 2005 in order to complete the installation.

19.	Click the option I Accept the terms in the License Agreement then click Next.

20.	Then enter your Name and Company for the Registration Information to get completed. Click Next to proceed.

Then check the installation path if it’s correct (by default it must be in C:\Program Files\Microsoft SQL Server, where the SQL Configuration Tools was previously installed). Click Next to proceed.

24.	Click Finish when it’s done. Congratulations! The installation of SQL Server Express 2005 is now complete!

25.	Again, check if it’s successfully installed in your pc by going to Start>Programs>Microsoft SQL Server, then the SQL Server Management Studio Express should appear.