Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • Accessing the Standard CGI Variables
    Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
  • INTRODUCTION TO C
    INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • Exercise 11.3: Polymorphism
    Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
  • The Command Button's KeyPress, KeyDown and KeyUp Events
    The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...

Wednesday, March 18, 2009

Installing SQL Server Express

This chapter talks about installing SQL Server Express. If you have a licensed 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) orlocalhost or 127.0.0.1.

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

Proceed to the next chapter for additional installation instructions.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)