MicroSoft Sql Server 2000

Understanding Microsoft SQL Server

Microsoft SQL Server is a scalable database system whose primary purpose is to serve as a back-end database for a client program, such as your Web browser, an accounting program, or a human resources application—anything that makes use of the data. In the most common usage scenario, a client program connects to SQL Server and requests some information, whereupon SQL Server processes the request and returns results.

Installing SQL Server 2000

Installing SQL Server 2000 is a snap—that is, if you stick to the default settings. I recommend that you postpone trying your hand at mission-critical installations until you actually understand the options and their ramifications.

Overview of SQL Server 2000 Editions

Stepping through the installation

Follow these steps to perform the installation:

1. Insert the Microsoft SQL Server 2000 Standard Edition CD into your CD-ROM drive. If your computer supports the autorun feature, the installation will start automatically; otherwise, find your CD-ROM from Windows Explorer and start autorun.exe.

2. From the very first installation screen, select SQL Server 2000 Components. The next screen gives you the following options:
* Install Database Server
* Install Analysis Services
* Install English Query
You may want to consider installing Analysis Services and/or English Query— some other time. These are advanced options that deserve a separate book, and I recommend mastering the basics before moving on.

3. Click Install Database Server. The Installation Wizard comes to life. It guides you through the whole installation process. (You can go back and change your choices until you click Finish.) You can install SQL Server 2000 either locally or on a remote machine, as shown in Figure 1-1.You need to specify your computer (server) name if you are installing on a remote machine. Virtual Server is an advanced option for enterprise-level database systems. The installation program detects any previous instances of SQL Server running on your machine and gives you appropriate install and/or upgrade options. Depending on what is already installed on your computer, you might have slightly different installation options enabled or disabled.

4. Enter your name and the name of your company in the spaces provided. Click Next to continue to the License Agreement screen.

5. Before you can proceed, you need to agree to the terms of the license agreement that comes with your copy of SQL Server 2000. Later in the installation process, you will be prompted to select a licensing mode; therefore, make sure that you select the proper licensing options.
6. Specify installation options, as shown in Figure 1-3. Choose Server and Client tools and click Next. (The two other options are for users working from remote servers.)

7. In order to install an instance of SQL Server, you need to specify a name (I specified MYVERYOWNSQL, as shown in Figure 1-4); every subsequent installation will have to have a different unique name. Only one instance will be designated as the default (the grayed-out check box on this screen indicates that I already have a default instance of SQL Server running). Click Next.

8.Select the type of setup you wish to perform. I recommend sticking with the Typical setup type until you have more SQL Server experience. Click Next. You also may want to change the physical location of the program and database files by clicking Browse. Generally, it is not a very good idea to keep program and data files in the same directory, as this can cause costly mistakes when you are maintaining your databases or installing service packs and upgrades.

9. Choose your SQL Server collation order, default language, and so on, as shown in Figure 1-5. Collation defines how your data will be compared and sorted. For English and any language using Latin characters, the choice is easy; for Asian characters, it might not be so obvious. The collation order specified here determines the default code page and sort order for all non-UNICODE characters and is the UNICODE collation order for all SQL Server system databases. The sort order determines whether operations on your data will be case-sensitive or not. click next

10. Unless you have a valid reason (for example, if you need direct access to your server from the Internet or from a client running on an Apple computer), I recommend leaving the Network Libraries screen with its default values, which are Named Pipes and TCP/IP. Click Next.

11. Define Services Accounts (see Figure 1-6). You can start each service on a different account, thus fine-tuning access privileges. I recommend selecting the same account for each service and auto-start for SQL Server. That way, the SQL Server and SQL Server Agent services will be started each time you log on to you machine account and won’t require special authorization. Click Next.

12. Specify the authentication mode to be used to start up SQL Server. SQL Server 2000 has built-in security to protect data from unauthorized access. If you choose Windows Authentication Mode your SQL Server databases will be accessible as soon as you log onto your account with your Windows NT/2000 login; Mixed Mode requires a user ID and password in order to connect to SQL Server after you log on. Click Next.

13. The setup process informs you that it has collected enough information to start the installation. This is your last chance to change your settings before the install. (Once you’ve got SQL Server up and running you’ll
always be able to change it through SQL Server itself, using the SQL Server Enterprise Manager interface or built-in commands.) Click Next. Unless you are installing evaluation software you see one more screen, which prompts you to choose your licensing mode. For the purposes of this book I select Licensing Per Seat—meaning that only one connection to my installation of SQL Server will be allowed at any one time.

Completing the installation and rebooting your computer

Depending on your computer resources the whole installation process should take between 15 minutes and an hour. Depending on the operating system you are running, the last screen you see may or may not prompt you to reboot. It is always a good idea to reboot your computer after installation, even if the install program doesn’t suggest it.

If you have followed the preceding steps, after restarting your computer and logging on you should see a small icon (a computer tower and a small encircled green triangle or encircled red square) in your system tray (usually in the lower right-hand corner, with the clock). This icon provides you with quick access to your SQL Server Service Manager. Make sure that the icon displays a small green triangle: This means that SQL Server is up and running. You can bring up the SQL Server Service Manager console by right-clicking the icon and then check the status of installed services: MSDTC, SQL Server and SQL Server Agent. You also can stop, start, or pause any of these services from this console. Depending on your installation you may or may not see some additional services, but these three should always be there.

You can find more information from following links:

Microsoft SQL Server 2005
Visit this portal for all the latest news and articles to help you evaluate Microsoft SQL Server 2005 for your data management and analysis needs.

SQL Server Express - Easy to Use
SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005. Free to download, free to redistribute, free to embed, and easy for new developers

SQL Server 2000 - Downloads
Get the latest SQL Server add-ins, updates, tools, and components.

SQL Server 2000 Security Update for Service Pack 2
This Microsoft Knowledge Base article contains a list of all the security fixes that are available for SQL Server 2000 Service Pack 2 (SP2).

 

---

| Copyright © www.readerstuff.com |