Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

How do I Install SQL Server Express?

Step 1

First, visit https://www.microsoft.com/visualstudio at Microsoft and download the following to your virtual or dedicated server:

SQL Server 2005 Express Edition SP2

SQL Server Management Studio Express

Double click the SQLEXPR.EXE file to start the setup

kb-install-sql-express-1

Step 2

Click Next to proceed.

kb-install-sql-express-2

Step 3

Click Install to proceed.

kb-install-sql-express-3

Step 4

Install the prerequisites and then click Next to proceed.

kb-install-sql-express-4

Step 5

Click Next to proceed.

kb-install-sql-express-5

Step 6

Click Next to proceed (you can ignore the Minimum Hardware Requirement message)

kb-install-sql-express-6

Step 7

Click Next to proceed

kb-install-sql-express-7

Step 8

Choose Entire feature will be installed on local hard drive for Client Components and click Next to proceed.

kb-install-sql-express-8

Step 9

Choose Mixed Mode, enter a strong password (8-16 characters mixed case is recommended), and click Next to proceed.

kb-install-sql-express-9

Step 10

Leave these boxes unchecked and click Next to proceed.

kb-install-sql-express-10

Step 11

Click Install to proceed.

kb-install-sql-express-11

Step 12

Wait for the installation to complete and then click Next to proceed.

kb-install-sql-express-12

Step 13

Click Finish to exit the SQL Installation.

kb-install-sql-express-13

Step 14

Double click on SQLServer2005_SSMSEE.MSI and choose Run to install SQL Server Management Studio.

kb-install-sql-express-14

Step 15

Click Next to proceed.

kb-install-sql-express-15

Step 16

Click Next to proceed

kb-install-sql-express-16

Step 17

Click Next to proceed.

kb-install-sql-express-17

Step 18

Click Next to proceed.

kb-install-sql-express-18

Step 19

Click Install to begin the installation.

kb-install-sql-express-19

Step 20

Installation is complete, click Finish to exit.

kb-install-sql-express-20

Step 21

Navigate to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager.

kb-install-sql-express-21

Step 22

Expand SQL Server 2005 Network Configuration, Right click on TCP/IP, and choose Properties.

kb-install-sql-express-22

Step 23

Click on Enabled and choose Yes to enable TCP/IP and click on the IP Addresses tab.

kb-install-sql-express-23

Step 24

Scroll down to TCP Dynamic Ports and make it blank.  Set the TCP Port to 2433.

kb-install-sql-express-24

Step 25

Click OK for this message dialog.

kb-install-sql-express-25

Step 26

Right click on My Computer and choose Manage.

kb-install-sql-express-26

Step 27

Expand Services, locate SQL Server, Right click, and choose Restart.

kb-install-sql-express-27

Step 28

Navigate to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.

kb-install-sql-express-28

Step 29

Choose your SQL Express instance and click Connect.

kb-install-sql-express-29

Step 30

You’ve completed installation of SQL Express and SQL Management Studio!

kb-install-sql-express-30

 

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.