Installing SQL Express on your dedicated or virtual private server

The article provides details on how to download and install SQL Express 2005 on your dedicated or virtual private server.

Windows 2003

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

Installing .NET 2.0

The first step for installing SQL Express is to install .NET 2.0 on your server. 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. CrystalTech 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 your Windows 2003 server.

Windows 2008

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=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&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. CrystalTech 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.

SQL Express is now running on your Windows 2008 server.

Add Feedback