SQL Server 2000 Administration in 15 Minutes a Week: Basic Installation - Page 4

May 10, 2002


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 Server."





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.

Mike
maubert@databasejournal.com
www.2000trainers.com


» See All Articles by Columnist Michael Aubert









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers