Ms sql server 2000 setup

The Squốc lộ VPS is a very popular Relational Database Management System, i.e. RDBMS. It owes its popularity not only lớn the producer"s strong sale actions but it is also a very efficient, stable, scalable và a quite secure database platform. Unfortunately, the hệ thống manufacturers prefer concentrating on efficiency rather than paying attention to security, and if they finally bởi it, it will be too late. The Microsoft SQL server"s most serious opponent, the Oracle9i server was introduced lớn the market last year with the nickname of "the unbreakable", which means "the unhackable". At that time its safeguards were no more than a nice catchword <1><2>, while the security problems are still being repaired <3>. The Linux PostgreSquốc lộ hệ thống, popular aao ước the users, has recently had some serious bugs removed <4><5><6>. There were also problems with MySQL <7> and the Sybase <8> - Microsoft Squốc lộ VPS is no exception here <10>. Can using a database hệ thống be secure in connection with these facts? Yes, if the server is correctly safeguarded.

Introduction

I shall discuss the patches that require the correct màn chơi of security are not available for the Evaluation version of the software. Moreover, the license limitations make this version unusable in a production environment.

You watching: Ms sql server 2000 setup

Other limitations are produced by the server"s OS - the SQL Server 2000 service can be installed on a Windows 2000 Server only (also Advanced & Datacenter) or Windows NT 4.0 Server (or Enterprise Edition). This latter platsize is no longer officially supported by Microsoft <10> therefore this article will focus on the installation of a Squốc lộ Server 2000 on a Windows 2000 Server platsize. Because of network security reasons, this VPS cannot be a tên miền VPS. It should belong to the entire domain name as a thành viên VPS to lớn enable users to use Squốc lộ Server services with no additional authentication required (which absolutely does not mean worsening the security but will enhance it due to the laông xã of a little secure Squốc lộ authentication). Still for security reasons, the Service Paông xã 3 tệp tin for Windows 2000 and the lademo patches <11> must be installed. Further, you should strenghten the server"s security by setting the GPO and/or local Security Policy options <12>. For appropriate settings to be applied to lớn a non-domain name controller server, tìm kiếm for the "Security Templates" application & go khổng lồ the "hisecws" filename <13>. Last but not least, you should ensure that the sysadmin tài khoản password is protected by a hard-to-crack password. No matter how carefully you set up security, if an attacker can guess the system administrator password, the quality password that is not protected against brute force attacks.

Getting installed

The Squốc lộ Server installation does not commence in a typical way - firstly you have to create an account for the service. If replication is not required nor are the other mechanisms using the SQL-initiated connections to other computers, this tài khoản should be defined in the Local Account Base (i.e. SAM). Otherwise you should define it in a tên miền. It should belong to lớn the Users group (in case of a tên miền trương mục - khổng lồ the Domain Users group). If you"re not going to use the SQL Server Agent, you could even resign from this level of permissions and place the accounts in the Guests (or Domain Guests) group. Let"s choose "sqlsvc" as the trương mục name in the following example installation process. You don"t grant any extra permission at the moment - the right of logging in as a service will be granted by the installation program. Remember to lớn choose a long and complicated password because your data"s security depends on it.

Having prepared the trương mục, run the installation - after inserting the installation CD-ROM a welcome screen should appear. Choose the SQL hệ thống components option & afterwards, the Install Database Driver. If your computer does not run CD-ROMs automatically (it is a recommended security action), you"ll have sầu lớn run the setup.bat file in the CD-ROM"s root directory manually. The SQL VPS service"s installation wizard will appear. On the first screen, clichồng the Next button, on the following one - the target location of the installation - a Local Computer. The very next screen presents you with the available installation options: creating a new installation, modifying (or deleting) the current installation, and finally the advanced options. Choose the mặc định, top option. Then it"s time for filling in your personal details. Clicking the Next button will lead you khổng lồ the license arrangement screen. Having confirmed it, choose the installation"s elements - the middle option, Server and Client Tools, that is provided to install the server"s services. Subsequently, choose the SQL server installation. You may run up lớn 16 instances, i.e. independently working Squốc lộ hệ thống services on one computer. You"ll usually be using only one instance at a time - otherwise you"d have sầu to lớn face the costs of extra licenses & the fact of efficiency limitations. That"s why you should choose the option of the default installation by leaving the Default field marked as it was from the beginning, and pass on lớn the next screen of the installation. This is where you choose the particular elements of the installation and its location on the hard drive. Click the Typical installation option but don"t skip lớn the next screen. Consider what kind of drive sầu you should be storing the databases (the Data Files option) - storing them on a dedicated drive (or, which would be even better, in a storage array system equipped with SCSI hard drives) will allow achieving optimal efficiency & slightly enhancing the data security.

Fig. 1: The SQL Server installation options

If you have chosen a dedicated drive sầu, remember setting up its safeguards (of course it has khổng lồ be a NTFS partition). The right permissions for a data-storage drive are:

 Administrators: Full Control SYSTEM: Full Control sqlsvc: Read và List Folder Contents

A reminder: the SQL data must not be compressed by the NTFS tệp tin system because this may cause a serious drop in efficiency or even faults when performing the queries. If you have sầu chosen a compressed partition, you should halt the Squốc lộ service right after the installation & decompress the data-containing directory. Leave the mặc định software file"s location, i.e. C:Program FilesMicrosoft SQL Server as it is. This directory will occupy approximately 1đôi mươi megabytes of the C: hard drive sầu space. After clicking Next you"ll have to lớn provide the program with the data of the earlier thiết lập account. The SQL Server installs two services (the MSSQLServer và the SQLServerAgent), so there"s a possibility of defining separate accounts for each of them, but you won"t need it.

Fig. 2: Setting up the service"s tài khoản

The following screen allows you khổng lồ choose the way of authenticating the Squốc lộ service"s users; choose the Windows Authentication Mode. Running the Squốc lộ in this mode requires that the users firstly have sầu to lớn log onto lớn the operation system. This is a very important option allowing you to lớn safeguard the Squốc lộ service with the use of the Windows authentication mechanisms

Fig. 3: The thiết lập of the authentication mode

Subsequently, clicking the Next button will move you to lớn a screen where you"ll be asked to lớn fill in the information on the kind và number of purchased licenses. Afterwards the Squốc lộ Server installation program will commence the installation procedure. When it is finished, a "thiết đặt complete" caption will appear on the screen. Installing the Service Paông chồng 2 for the Squốc lộ Server is your next stage. Download the 49-megabyte SQL2KSP2.exe pháo tệp tin from Microsoft"s website và run it on your hệ thống. An important reminder: the Service Paông chồng 2 may only be installed on the full version of the Squốc lộ Server; the evaluation version cannot be "repaired" nor secured with newer patches because this requires the SP2 to be installed. Having run the SQL2KSP2.exe file, you"ll be asked about the installation folder. Contrary to lớn what your intuition tells you, this question is about the directory where the temporary installation files are lớn be decompressed, not about the Squốc lộ Server service"s directory. Choose any temporary directory, such as the C:winnt empsql2ksp2 or the mặc định C:sql2ksp2. When the decompression is finished, you"ll get informed that "The package has been delivered successfully". At this moment you may start the proper installation of the Service Pachồng 2 for the SQL Server 2000. Run the cài đặt.bat file which has been copied lớn the earlier specified directory. Then you"ll pass two screens of the installation wizard. In the "Connect lớn Server" window, mark the mặc định option of choosing the authentication on the Squốc lộ VPS - The Windows tài khoản information ..... - which will make you use the Windows Authentication Mode. At the moment when the Service Pack 2 for SQL Server 2000 is finished, this information will appear on the screen: "You should now backup your master & msdb databases since this installation has updated their content" - this advice shouldn"t be ignored. However, if you haven"t installed any databases nor changed the manufacturer"s cài đặt of the server, you don"t have sầu lớn pay attention khổng lồ it. A "thiết đặt complete" window will follow the confirmation.

The Microsoft Data Access Components software package version 2.6 is one of the components of the SQL Server 2000. The Service Pack 2 updates it khổng lồ the 2.6 SP2 version <12>. You should consider updating it khổng lồ version 2.7 because of the MS02-065 fault.

See more: Free Download All Football Manager Games Free Torrent, Football Manager 2016 Download

<13>. To vị this you have sầu khổng lồ connect lớn Microsoft"s trang web <14> & choose the MDAC 2.7 Refresh for x86 - English option from the các mục and then press the Go to lớn Download button. Having downloaded the patch, run the MDAC_TYPhường.EXE tệp tin. After giving your consent to lớn the license agreement, click Next so that the program will kiểm tra if installing the MDAC 2.7 is possible. What you"ll see next will be an "Installing the Software" screen và quite a funny message, "Click Finish khổng lồ begin installation". The MDAC components will be copied khổng lồ the systems after you cliông xã the Finish button. On the following "Setup is complete" screen cliông xã Close. You may kiểm tra the currently installed MDAC version in the HKLMSOFTWAREMicrosoftDataAccess registry key.

Fig. 4: Upgrading lớn Version 2.7

The last patch to be installed on your computer is the MS02-061 patch <16>. This is lớn update the Squốc lộ Server service files by removing major security holes that were found in Service 2. Unfortunately, in contrast to lớn the previous patches, those for the SQL Server are not installed by mặc định with the system and you must vì chưng it manually. Go to lớn the Microsoft Security Bulletin <16> and navigate lớn the links associated with the Q316333 issue <17>. It contains information on this patch & all previous Squốc lộ Server security patches. The SQL Server patches are cumulative ones, i.e. the most recent patch for any component will contain all the fixes for that component of the product. If so, all you need is to install one - the lakiểm tra patch. Go lớn the information about the patch: "October 16, 2002 Release" and then download the 8.00.0686_enu.exe. This is a 10MB self-extracting ZIP file(more specifically, it is a WinZip Self-Extractor). Once the tệp tin is started, you will be prompted lớn indicate the destination directory you wish to have sầu the patch files copied - use a temporary directory, for example C:WINNTTEMPMS02-061 (a relevant sub-directory will be created automatically).

Fig. 5: Unzipping the MS02-061 patch

Once you have extracted the files, you will see the message about the number of copied files. Quit WinZip. Go to the previously indicated directory and navigate lớn find the"x86" sub-directory. It contains patch files lớn be copied manually lớn appropriate directories, namely SQL Server & README.TXT files that contains the installation instructions.

Fig. 6: The MS02-061 patch files after extraction

These instructions describe the patch files & operations that are necessary for the installation:

1.

See more: Download Vở Tập Viết Tiếng Trung : Pdf, Tải Giáo Trình Luyện Viết Chữ Hán Đẹp

Stopping the SQL Server và SQL Server Agent services. To bởi vì this, you can either use the "Services" application belonging lớn the administrative tools of the computer, or make two operations in the commvà line:

net stop sqlserveragent

net stop mssqlserver

2. Making backup copies of these files that will be patch-updated (the most convenient method is to lớn change filenames). The files are to be left in their original locations: