1. Preparation
1.1 Setup program will automatically check your IE version. If it is lower than version 5.5, you need to upgrade to higher versions by clicking the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e1550cb-5e5d-48f5-b02b-20b602228de6&displaylang=en1.2 Database management system installing
| Windows 2000Server /Advanced Server | Windows Server 2003 | |
| MSDE2000 | Y | Y |
| MS SQL Server2000 | Y | Y |
MS SQL Server2000 and MSDE2000 need to install MS SQL Server 2000 Service Pack3.
1.2.1 MS SQL Server2000 Installing
a. Choose "Mixed Mode" to install
b. If you install MS SQL Server2000 in Windows Server2003 system, when you system appears 'this SQL server version is not supported by current system', please choose "Next" to continue your installation. Once you finish the installation, you may update it by downloading MS SQL Server2000 Service Pack3 via the following link:
http://download.microsoft.com/download/8/7/5/875e38ea-e582-4ee2-9485-b459cd9c0082/sql2ksp3.exe
1.2.2 MSDE2000 Installing
MSDE2000 is contained in MS Office XP/2003 disc, or you might want to download from the following links:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e1550cb-5e5d-48f5-b02b-20b602228de6&displaylang=en (Win98/2000/XP/20003)
a.MSDE2000 installing for MS Office XP
Back to DOS prompt and type "setup securitymode=sql", then press "Enter", the password for 'sa' is empty.
b.MSDE2000 installing for MS Office 2003
Find MSDE200 path in the MS Office 2003: office11/msde2000, then double click it to installing
Click "Finish":
Input "Yes":
Click “OK”.
Open DOS command prompt and type:
>d: (followed by the folder path)
>cd\
>cd d:\sql2ksp3\msde Click [Enter].
then type:
setup sapwd="sa" securitymode=SQL disablenetworkprotocols=0
then press [Enter].
'sapwd' stands for 'sa' password', it is also used for "Administrator password" in the procedure of "Database Installing"; it may be modified by user.
c. Downloaded MSDE2000 installation
(1) Extract file
(2) Open DOS command prompt
(3) Get into extracted directory
(4) Type:
setup sapwd="sa" securitymode=SQL disablenetworkprotocols=0
then press [Enter].
'sapwd' refers to "sa" password. It is used for "Administrator Password" at the stage for "Database Installation". User could change it later.
Both MS SQL Server2000 and MSDE2000 requires "Mixed Mode" installation. At this mode, system supports not only Windows ID verification, but also SQL ID verification.
(3) Before installing the system for Office 2000/XP/2003, please check the system settings and reset the "Macro" configuration