2.2.3 Installing SQL Server 2000
,
belstaff jacken
relatively simple to install SQL Server 2000,
outlet belstaff, the process is similar to other Microsoft Windows products. We installed SQL Server 2000 Standard Edition, for example, the installation process and explained as follows:
· to SQL Server 2000 CD-ROM into the drive. If you have Autorun function,
belstaff jacket, the installer splash screen appears, or directly run CD Autorun program. If the operating system is Windows 95,
belstaff blouson, you need to select one of the I \ Here we select \ Appears to install SQL Server 2000 Welcome to the next dialog box appears as shown in Figure 2-1 Select Computer dialog box to install the software. \
· select \
If you select \
· Record Unattended. ISS file: to automatically install to create an initial configuration file;
· Registry Rebuild: repair a damaged installation;
· Maintain a virtual server fo * ** ilover clustering: maintain a virtual server.
· in Figure 2-2 usually select \ Enter the user name, company name, license agreement information interface appears. Choose to accept the copyright agreement, enter the product serial number dialog box appears.
· then appear as shown in Figure 2-4 Select Installation Type Options dialog box. Select \
· then appear as shown in Figure 2-5, set the instance name of the dialog box. Select \
· the next set appears as shown in Figure 2-6 Setup Type dialog box. In this dialog you can modify the procedure for SQL Server 2000 installation directory and data files directory. A typical installation of \
· then appear as shown in Figure 2-7 Custom Install Components dialog box. Can be chosen by the SQL Server components to install.
· then appear as shown in Figure 2-8 to set service startup account the implementation of the dialog box. Need to enter a NT network account as SQL Server startup account to log on NT network, so that SQL Server service or SQL Server Agent service on the network as an NT service. This account must have been established by the domain user administrator, located in the Regional Administrators group, and is set password is always effective,
belstaff jackets sale, you can log in any time or NT network itself is the domain user administrator account. And a separate SQL Server service or as a SQL Server Agent service start the implementation of the specified account.
· shown in Figure 2-9 appears next set authentication mode dialog box. You can choose Windows Authentication Mode or Mixed Mode authentication.
· then appear as shown in Figure 2-10 to set the check mode (Collation) dialog box. The so-called parity refers to the way how to compare the sort of data processing operations display a set of rules. SQL Server uses parity information to classify, sort,
belstaff sale, display character data Here you can specify three sorting methods:
· Accent sensitive: the dictionary order, case insensitive, there is a change as different sounds of letters;
· Case sensitive: dictionary order, case-sensitive, a change in tone of the letters as different;
· Binary: binary sort, this is the fastest sort, Accent sensitive sorting than 20% faster than Case sensitive sort about 35% faster.
· then appear as shown in Figure 2-11 Network Settings dialog box library. If you are not familiar with the network protocol is recommended to use the default settings SQL Server.
the options below:
· Named Pipes (Named Pipes)
SQL Server default settings for installation on the NT network to allow local or network communications.
· TCP / IP Sockets (TCP / IP socket)
default socket is 1433.
· Multi-Protocol (Multi-Protocol)
multi-protocol use of Windows NT RPC (Remote Procedure Call) to communicate the structure. Multi-protocol support NWLink IPX / SPX, TCP / IP and Named Pipes protocols.
· NWLink IPX / SPX
Novell network protocol.
· Apple Talk ADSP
for Apple Macintosh users to use Apple Talk with the SQL Server connection.
· Banyan VINES
Intel PC based on the SQL Server support for a network system.
· following confirmation appears as shown in Figure 2-12 Start Copying Files dialog box. If you no longer modify the installation settings, you can start copying files, the installation work.
· last seen in Figure 2-13 shows the end of the SQL Server installation dialog.