printall en us

7/29/2019 PrintAll en US

1/53

Page 1 53 total

MSDE2000 and SP4 Installation

MSDE2000 Requirement for OS

Windows XP Home, Windows XP Professional, Microsoft Windows 98

Windows Me, Windows NT Workstation 4.0 Service Pack 5 or higher, Windows

NT Server 4.0 Service Pack 5 or higher, Windows NT Server 4.0 Enterprise

Edition Service Pack 5 or higher, Windows 2000 Professional, Windows 000

Server, Windows 2000 Advanced Server or Windows 2000 Datacenter Server

MSDE2000 Requirement for Hardware (Min)

1. Computer:

Intel or compatible Pentium 166 MHz or faster

2. RAM:

Desktop engine: Windows XP: 128 MB, Windows 2000: min. 64 MB, other OS:

min. 32 MB

3. Hardware Space:

44 MB

4. Monitor:

VGA or higher resolution

800x600 or higher resolution for SQL Server image tool


2/53

Page 2 53 total

Installation

1. Unzip the installation pack


3/53

Page 3 53 total


4/53

Page 4 53 total

2. Access Command Line Mode


5/53

Page 5 53 total

3. Access unzipped path

4. Install Instance

1Install default instance and use Windows Authentication. Enable TCP/IP and

Named Pipes.


6/53

Page 6 53 total

2Install named instance name and use Windows Authentication. Enable

TCP/IP and Named Pipes.

3Install default instance and use Mixed Authentication. Enable TCP/IP and

Named Pipes.


7/53

Page 7 53 total

4Install named instance and use Mixed Authentication. Enable TCP/IP and

Named Pipes.

5. Start Installation


8/53

Page 8 53 total

6. Run Service Manager

Other

1. MSDE only supports 5 or less workstations to be connected at the same

time

2. MSDE: the largest memory is 2Gbyte.


9/53

Page 9 53 total

SQL Server 2000 and SP4 Installation

SQL Server 2000 Requirement for OS

1. Enterprise Edition:

Microsoft Windows NT Server 4.0 Service Pack 5 or higher, Windows NT

Server 4.0 Enterprise Edition Service Pack 5 or higher, Windows 2000 Server,

Windows 2000 Advanced Server or Windows 2000 Datacenter Server

2. Standard Edition:

Microsoft Windows NT Server 4.0 Service Pack 5 or higher, Windows NT

Server 4.0 Enterprise Edition Service Pack 5 or higher, Windows 2000 Server,

Windows 2000 Advanced Server or Windows 2000 Datacenter Server

3. Developer Edition:

Windows XP HomeWindows XP Professional, Microsoft Windows NT

Workstation 4.0 Service Pack 5 or higher, Windows NT Server 4.0 Service

Pack 5 or higher, Windows NT Server 4.0 Enterprise Edition Service Pack 5 or

higher, Windows 2000 Professional, Windows 2000 ServerWindows 2000

Advanced Server or Windows 2000 Datacenter Server

SQL Server 2000 Requirement for Hardware (Min)

1. Computer:

Intel or compatible Pentium 166 MHz or faster

2. RAM:

Enterprise Edition: min. 64 MB, 128 MB or larger is recommended

Standard Edition: min. 64 MB

Developer Edition: min. 64 MB

3. Hardware Space:

SQL Server Database Components:95 to 270 MB available hardware CPU

space for server, 250 MB for typical installation

Analysis ServicesMinimal Installation 50 MB, typical installation 130 MB

Query in English:80 MB


10/53

Page 10 53 total

4. Monitor

VGA or higher resolution

800x600 or higher resolution for SQL Server image tool

Installation

1. Install SQL Server 2000


11/53

Page 11 53 total


12/53

Page 12 53 total


13/53

Page 13 53 total


14/53

Page 14 53 total

2. Create default instance or named instance.


15/53

Page 15 53 total

3. Choose the local system account or domain user account


16/53

Page 16 53 total

4. Choose Windows Authentication or Mixed Mode Authentication


17/53

Page 17 53 total


18/53

Page 18 53 total

5. Install Service Pack 4


19/53

Page 19 53 total


20/53

Page 20 53 total

6. Setup for valid SA password is recommended


21/53

Page 21 53 total


22/53

Page 22 53 total


23/53

Page 23 53 total

7. Enable TCP/IP and Named Pipes


24/53

Page 24 53 total

8. Run SQL Server and SQL Server Agent


25/53

Page 25 53 total

Other

1SQL2000 support 5 or more workstations to be connected at the same time

2SQL2000: the largest memory is1024Gbyte


26/53

Page 26 53 total

SQL Server 2005 Installation

SQL Server 2005 Requirement for OS

1. Enterprise Edition

Windows 2000 Server SP4Windows 2000 Advanced Server SP4Windows

2000 Datacenter Edition SP4Windows 2003 Server SP1Windows 2003

Enterprise Edition SP1Windows 2003 Datacenter Edition SP1Windows

Small Business Server 2003 Standard Edition SP1Windows Small Business

Server 2003 Premium Edition SP1

2. Developer Edition

Windows 2000 Professional Edition SP4, Windows 2000 Server SP4

Windows 2000 Advanced Server SP42Windows 2000 Datacenter Edition

SP4Windows XP Home Edition SP2, Windows XP Professional Edition SP2,

Windows XP Media Edition SP2, Windows XP Tablet Edition SP2,Windows

2003 Server SP1Windows 2003 Enterprise Edition SP1Windows 2003

Datacenter Edition SP1Windows Small Business Server 2003 Standard

Edition SP1Windows Small Business Server 2003 Premium Edition SP1

3. Standard Edition

Windows 2000 Professional Edition SP4, Windows 2000 Server SP4

Windows 2000 Advanced Server SP4Windows 2000 Datacenter Edition

SP4Windows XP Professional Edition SP2, Windows XP Media Edition SP2,

Windows XP Tablet Edition SP2,Windows 2003 Server SP1Windows 2003


27/53

Page 27 53 total

Enterprise Edition SP1Windows 2003 Datacenter Edition SP1Windows

Small Business Server 2003 Standard Edition SP1Windows Small Business

Server 2003 Premium Edition SP1

SQL Server 2005 Requirement for Hardware (Min)

1. Computer:

Pentium III compatible CPU or faster

min.: 600 MHz

Recommendation: 1 GHz or higher

2. RAM:

min.: 512 MB

Recommendation: 1 GB or higher

Max. : The maximal RAM of OS

3. Hardware Space:

Database engine and data file copy and search the whole doc: 150MB

Client Components: 12MB

Management Tool: 70MB

4. Software Requirement:

Microsoft Windows Installer 3.1 or higher and Microsoft data access

components (MDAC) 2.8 SP1 or higher

Microsoft Internet Explorer 6.0 SP1 or higher

Installation


28/53

Page 28 53 total

1. Install the necessary components for SQL Server Installation


29/53

Page 29 53 total


30/53

Page 30 53 total


31/53

Page 31 53 total

2. Check System Configuration


32/53

Page 32 53 total

3. Choose the necessary components for Installation

4. Create default instance or named instance


33/53

Page 33 53 total


34/53

Page 34 53 total

5. Start Installation SQL Server 2005


35/53

Page 35 53 total


36/53

Page 36 53 total

6. Enable Named Pipes and TCP/IP


37/53


38/53

Page 38 53 total

Installation

1. Run Install.htm

2. Install SQL Server 2005 as the procedure shown


39/53

Page 39 53 total

1) Confirm OS needed and its service pack

2) If the previous version of SQL2005 is installed, the existing data should

backup.

3) Uninstall the existing program, then uninstall Microsoft .NET Framework1.2

or 2.0 (don't uninstall 1.0 and 1.1)

4) Install Microsoft .NET Framework 2.0

5) Install Microsoft SQL Server 2005 Express


40/53

Page 40 53 total


41/53

Page 41 53 total


42/53

Page 42 53 total


43/53

Page 43 53 total

Create Default Instance or Named Instance

Set up the Service Account, the built-in account or domain user account.

Set up the Authentication, Windows or Mixed


44/53

Page 44 53 total


45/53

Page 45 53 total


46/53

Page 46 53 total


47/53

Page 47 53 total

6) Install Microsoft SQL Server 2005 Management Studio Express


48/53

Page 48 53 total


49/53

Page 49 53 total


50/53

Page 50 53 total


51/53

Page 51 53 total

7) Run SQL Server Management Studio Express CTP


52/53

Page 52 53 total

8) Access SQL Server Configuration Manager, change Named Pipes and

TCP/IP to be enable


53/53

Other

1. SQL Server 2005 Express: each database in one instance has 4GB

2. If SQL Server 2005 Express is running on WinXP Home, it can support 5 or

less workstations to be connected. If running on Win2000 or WinXP Pro, it can

support 10 workstations to be connected.

printall en us

Documents