Tutorials » SqlServer tutorials »

Installing SQL Server Express

This chapter explains how to install SQL Server Express

This chapter talks about installing SQL Server Express. If you have a licesed version of full SQL Server 2005, you can follow the same steps. The installation process is almost the same.

After downloading SQL Server Express, double click on the file SQLEXPR.EXE to start installation. The setup wizard will guide you through various steps.

The first few steps are very obvious. You can accept the terms and conditions and proceed.

In the feature selection dialog, by default, only the database services is selected. Click on the second item (Client Components) and select the option "Will be installed on local hard drive". This will install all client components also in addition to the database services.

Click NEXT to proceed.

In the next screen, you have to select the INSTANCE NAME. You have 2 options:

1. Select default instance
2. Select an instance name

The default name shown will be "SQLExpress". You may leave it as it is, or change it to "default instance". The point is, you have to remember what option you selected.

If you choose the "default instance", then you will be refering to your SQL Server instance with the name (local) or localhost or

If you choose "SQLExpress", then then you will be refering to your SQL Server instance with the name (local)\SQLExpress or localhost\SQLExpress or\SQLExpress.

Proceed to the next chapter for additional installation instructions.

Next Chapter: Selecting authentication mode while installing
Previous Chapter: Download SQL Server Express 2005
More Chapters: Sql Server Tutorials
More Tutorials: Tutorial Index

Top Contributors
    Last 7 Daysmore...

    Awards & Gifts

    Online Members

    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India