Microsoft SQL Server Setup
Microsoft SQL Server is an application used to create
computer databases for the Microsoft Windows family of server operating systems.
It provides an environment used to generate databases that can be accessed from workstations, the web, or other
media such as a personal digital assistant (PDA). Microsoft SQL Server is
probably the most accessible and the most documented enterprise database
environment right now. This also means that you can learn it a little
quicker than most other database environments on the market.
On this site, we provide lessons and other topics on how to
use Microsoft SQL Server. To limit the number of instructions given in the
lessons and make them a little easier, this web site deals only with Microsoft
SQL Server 2000, no other version (such as 6.5, 7, or Express), no MSDE
(although you would be able to follow most lessons on this site with the MSDE,
the problem is that it doesn't include an interface and some of its results in
the Command Prompt are not "cute").
Getting Microsoft SQL Server
In order to follow the lessons on this site, you must have
access to a computer in which Microsoft SQL Server is installed. To start, you
must have a computer that runs an appropriate operating system. If you are just
learning, which is assumed for all lessons on this site, you can use a Microsoft
Windows >= XP Home Edition: that includes Windows XP Home Edition, Windows XP
Professional, Windows 2000 Professional, or any version of Windows Server 2003.
In this case, you must install Microsoft SQL Server 2000 Developer Edition.
To make it possible for you and other students to study
databases and SQL, Microsoft made available a trial version of Microsoft SQL
Server. This full version is available from the Microsoft web site. This is
something beneficial because most companies would not give such a long trial version
of an important software product: for 120 days, you should be able to learn as
must as possible and be able to move on, such as finding a job or starting a
To get the trial edition of Microsoft SQL Server, go to the Microsoft
web site, do a search on "trial software" (normally, there is usually
a Trial Software link on the home page), and follow the links to locate the
trial edition of Microsoft SQL Server. This is a (very) big product: 274062 KB. For
all of the lessons of this site, we will use the developer edition of Microsoft
SQL Server, which is the same you download from the Microsoft web site.
Once you get serious with MS SQL Server, you would use
Microsoft SQL Server Enterprise Edition.
The installation of Microsoft SQL Server, like that of
various modern products is fairly easy, whether you are using a CD called SQL
Server Developer Edition, a DVD or a downloaded edition. If you have it on
CD or DVD, you can put it in the drive and follow the instructions on the
screen as we will review them.
The following steps describe the installation on a Microsoft Windows 2000 Server by the
Administrator account, a Windows XP Home Edition, a Windows XP
Professional, or the downloaded edition on a Microsoft Windows 2000