Lesson 1: Preparing to Install SQL Server 2005

Editions of SQL Server 2005

Edition	Description
Enterprise	Highly scalable and available enterprise-level database server (OS도 엔터프라이즈로 해야 함.)
Standard	Database server for department-level applications (클러스터링 2노드까지 지원된다.)
Workgroup	Database for workgroup or branch office operations (리플리케이션 기능 포함, 국내에서는 잘 사용하지 않음)
Express	Version of SQL Server 2005 for disconnected clients or stand-alone applications
Compact	Compact database for smart devices
Developer	Enterprise edition licensed for development and testing use only (XP에도 깔린다)

32bits OS인 경우 4GB 초과메모리 쓸 경우, Boot.ini 수정해야 함.

	Express	Standard	Workgroup	Enterprise	Developer
Windows Server 2003 SP1 (all PC editions)	O	O	O	O	O
Windows XP SP2 (Home Editions)	O				O
Windows XP SP2 (Professional, Media Center and Tablet Editions)	O	O	O		O
Windows 2000 Professional SP4	O	O	O		O
Windows 2000 Server SP4 (all editions)	O	O	O	O	O

Default Instance
- Identified by the network name of the computer on which it is running
Named Instance (클러스터를 구성할때는 사용됨)
- Identified by the network name of the computer plus an instance name

Processor license
- Requires a single license for each CPU in the operating system instance running SQL Server
Server plus device CALs
- Requires a license for the computer running the Microsoft server product, as well as a CAL for each client device
Server plus user CALs
- Requires a license for the computer running the Microsoft server product, as well as a CAL for each user

Services
Using a domain user account
- Specifies a domain user account that uses Windows Authentication
Using the Local System account
- A powerful, built-in account that has full access to the computer
Using the Network Service account
- Accesses network resources using the credentials of the computer account

Windows collations
- Based on the rules for an associated Windows locale
SQL collations
- Matches the attributes of common combinations of code page number and sort order that may have been specified in earlier versions of SQL Server
Default collation and sort rules
- SQL Server applies the default if you do not designate a collation and select sort rules

Versions
- SQL Server 2000 Service Pack 3 (SP3) or later
- SQL Server 7.0 SP4 or later
Upgrade Adviser
- Analyzes installed SQL Server 2000 or SQL Server 7.0 components
Database compatibility
- Set database level options to retain compatibility with earlier versions of SQL Server

Component update → SQL Setup MSI (Run System Configuration Checker → Select Features → Specify Install Type → Install Features)

Checks installation requirements

Component	Description
SQL Server Database Services	Database engine, replication, and full-text search
Analysis Services	Server and tools for online analytical processing (OLAP) and data mining
Reporting Services	Services for generating and distributing reports
Notification Services	Platform for applications that send notifications
Integration Services	Tools and components for transferring data
Workstation components, Books Online and development tools	Tools and documentation

Creating an .ini file
- You can create an .ini file for unattended installation using any text editor
Starting an unattended installation