2003server R2 + SQL SP4 environment configuration

Because of the work requirements you need to configure a Windows 2003 server R2 + SQL SP4 environment:

One, 2003server

Prepare the system: MSDN download distinguish between x86 or x64 there are altogether two CDs

Preparation software: Win$man

Prepare peu tray

1. Motherboard Setup: This computer is the Lenovo brand machine, need to open in the BIOS to allow UEFI boot-related options. Because the installation is 2003server, you need to change the disk from Achi mode to IDE mode.

2. Format the hard drive: Enter PE with Diskgenius after you delete all partitions, convert the disk to an MBR partition (because the new computer is typically partitioned with GPT) and then start the partition.

3. System installation: Unzip or mount the system as a virtual optical drive, open the Win$man tool, follow the wizard prompts to select the system path, installation location and boot location. The system will restart automatically, go to the blue screen to start the installation, follow the wizard to install, the system installation is complete.

4. Other specific settings: (1) Drive Life Card driver version, (2) Install security software, (3) browser, (4) VNC and so on.

Second, sql2000 SP4 installation

Preparation: SQL2000 installation package, SQL2000SP4 patch installation package

1.sql2000 installation: Unzip the SQL2000 installation package after opening the file setup.exe will be prompted to request from the installation folder to find three folders Setup.ext to install each, follow the Prompts Wizard installation, note Select Hybrid authentication, set the SA password.

2.SP4 Patch installation: Pressurized file Open Setup.dat Wait a while, there will be a wizard, gradually installed.

Tips

1. How do I view the specific version of the system?

Command: Msinfo32 or winver (measured 2003serve not good) or DxDiag

2. How do I view the specific version of SQL?

(1) Open Enterprise Manager to find out about, find version number

(2) New query write command line SELECT @ @version run to see the results below.

3. Sometimes after the system completes the USB all does not make, also is inside the motherboard changes the USB mode relations.

2003server R2 + SQL SP4 environment configuration