Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 11, 2002

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

By Michael Aubert

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.


» See All Articles by Columnist Michael Aubert

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM