The article provides details on how to download and install SQL Express 2005 on your Computer.
There are 3 individual downloads that are required for SQL Express 2005 and have to be installed in the following sequence.
A. Microsoft .NET Framework Version 2.0 Redistributable Package Release Candidate (x86)
B. Microsoft SQL Server 2005 Express edition
C. Microsoft SQL Server Management Studio Express
Requirement: A, B & C for Windows 2003 Server
Requirement: A & C for Windows XP
Installing .NET 2.0
The first step for installing SQL Express is to install .NET 2.0 on your Computer. Though .NET 1.1 is installed, SQL Express requires the .NET 2.0 framework to function properly. To download .NET 2.0, go to the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en
1. Click the download button and then click save. Choose a location on your hard disk for the .NET install file.
2. Go to the location where you saved the .NET executable and double click on dotnetfx.exe.
3. Click Run if prompted by a security warning.
4. Click Next to start the install.
5. Accept the terms of the license agreement and then click Install.
6. Allow the Install Wizard to complete and then click Finish.
Installing SQL Express
Now that .NET 2.0 is installed on your server, you can proceed to install SQL Express. To do so, go the the following link:
http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en
1. Click the SQLEXPR.EXE download link and then click Save. Choose a location on your hard drive for the sqlexpr.exe file.
2. Go to the location where you saved the SQLEXPR.EXE executable and double click on it.
3. Click Run if prompted by a security warning.
4. Check “ I accept the licensing terms and conditions” and then click Next.
5. At the end of configuration process, click Next.
6. The Installation Wizard will now appear and click Next to proceed.
7. After the configuration check completes, click Next.
8. Enter a name and company, then click Next.
9. Click the red X next to Connectivity Components and choose “will be installed on local hard drive” (this is optional) then click Next.
10. ZNet India recommends Mixed Mode. If you have chosen Mixed Mode, specify a password for the SA.
11. Uncheck the boxes for error a usage report setting, then click Next and Install.
12. Wait for setup to complete, then click Next and Finish.
Installing SQL Server Management Studio Express
The last step will be to install SQL Server Management Studio Express. This is the new version of Enterprise Manager. To download, go to the following link:
http://go.microsoft.com/fwlink/?LinkId=65110
1. Click save when prompted to download SQLServer2005_SSMSEE.msi Choose a location on your hard drive for the SQLServer2005_SSMSEE.msi.
2. Go to the location where you saved the SQLServer2005_SSMSEE.msi executable and double click SQLServer2005_SSMSEE.msi.
3. Click Run if prompted by a security warning.
4. Click “I accept the terms in the license agreement” and then Next.
5. Specify a name and company then click Next.
6. Click Next at the feature selection, then click Install.
7. Wait for setup to complete, then click Finish.
SQL Express is now running on you computer.
