15. Selecting the Network Libraries is one of the last decisions you need to
make. In order for clients to access the SQL Server, the Server and Clients must
be using a compatible protocol. The decision on which protocols you will use
will depend on what type of clients you are serving and what network protocols
you use on your network. Note that Named Pipes are only available on Windows NT
4.0 or Windows 2000. We will discuss the Named Pipes and TCP/IP Network
Libraries in more depth later in this series.
Click to Enlarge
Keep the default settings and click Next.
16. The installation now informs us that it has enough information and can
continue. Note that if you need to go back and change anything you must do so
now. Once you click Next you will be unable to go back.
Click to Enlarge
Click Next to continue the installation.
17. We must now choose from one of the two licensing modes:
Per Seat -- Requires a SQL license and a Client Access License (CAL) for each
device that accesses the SQL Server.
Processor License -- Requires a license for each processor SQL Server will use.
It is best to buy Per Seat licenses when you have a known number of clients that
access many servers. On the other hand, processor licenses are best used when
you have an unknown number of clients (that normally vary widely from hour to
hour) such as an e-commerce website.
Enter the type and number of licenses you have purchased and click Continue.
18. The installation copies the files to your hard drive and then informs you
when it has completed.
19. You can now locate the tools used to work with your SQL Server by clicking
"Start" on the taskbar, selecting "Programs", and then selecting "Microsoft SQL
That finishes up our look at a basic installation of SQL Server 2000. Keep in
mind if you are not using the same exact version of SQL server I am, your
installation may vary slightly (ex: I used a copy of SQL server that does not
require an installation key). Next week I will explain some of the more advanced
topics when installing SQL Server 2000.
If you have any technical questions please post them on the SQL message board.Please send any non-technical questions, comments, and feedback to my email. I hope you are finding this
series to be a useful one, and I'm looking forward to your feedback.
See All Articles by Columnist Michael Aubert