The processor in the computer on which you intend to install SQL Server must be an Intel Pentium or compatible 400MHz or higher processor. Microsoft recommends that you use a 700MHz or higher processor.
A SQL Server 2005 Enterprise Edition installation must have a minimum of 128 MB of memory, in addition to that required by the operating system.
Microsoft recommends that you use at least 512 MB of memory.
SQL Server 2005 Standard Edition and Developer Edition require a minimum of 64 MB of memory. Express Edition requires 64 MB of memory when installed on Microsoft Windows® 2000 or Windows 2003, and 32 MB on Windows XP.
Hard disk requirements
The SQL Server 2005 database components require between 95 and 300 MB of disk space, depending on the specific options chosen. A typical installation requires 250 MB of disk space.
If you choose to install SQL Server 2005 Analysis Services, you will require an additional 50 MB of disk space for a minimal installation, or 130 MB for a typical installation.
If you choose to install SQL Server 2005 Reporting Services, you will require an additional 5.5 MB of disk space for a minimal installation, or 8 MB for a typical installation.
Additional hardware requirements for typical installation scenarios include:
Monitor (SQL Server administrative tools are optimized for a screen resolution of 1024 x 786)
Select the features you want to install. You can select predefined groups or use the Advanced option to select individual components for each feature.
Select whether to install a default instance or a named instance.
If you are installing on a Windows cluster, enter cluster configuration information.
Enter service account information for the SQL Server 2005 services.
Select an authentication mode. You can select Windows Authentication or Windows and SQL Server Authentication.
Select a collation setting.
If you selected the Reporting Services feature in step 10, enter Reporting Services configuration information.
Click Finish when installation is complete.
Verify the installation by performing the following tasks:
• Examine the Setup log files located in the C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files folder.
The Summary.txt file located in the C:\Program Files\Microsoft SQL
Server\90\SetupBootstrap\LOG\ folder lists the log files created.
• Examine the status of the SQL Server services installed.
• Connect to SQL Server using sqlcmd.exe or SQL Server Management Studio.
Chi tiết cài đặt:
Phiên bản cài đặt Microsoft SQL Server 2005 Enterprise for Windows 2003 Enterprise with SP1.
Cấu hình máy CPU: Intel Xeon – 3.2 GHz; RAM: 1GB (Intel Serverbroad).
Virtual Memory: 1024 3000 MBs.
Host: SRV_ORA2(IP: 172.29.8.12).
Hệ điều hành: Windows Server 2003 – Enterprise Edition with SP1.
Bước 1: Chạy tập tin Setup.exe
Bước 2: Chọn
Bước 3: Chọn
Bước 4: Chọn
Bước 5: Chọn
Bước 6: Chọn
Bước 7: Chọn
Bước 8: Chọn
Bước 9: Chọn
Bước 10: Chọn
Bước 12: Chọn sau đó chọn
Bước 13: Chọn
Bước 14: Chọn sau đó chọn
Bước 15:Chọn , nhập password cho user sa sau đó chọn
Bước 16: Chọn
Bước 17: Chọn
Bước 18: Chọn
Bước 19: Chọn
Bước 20: Chọn
Bước 21: Chọn
Bước 22: Chọn
Bước 23: Chọn để khởi động lại server.
Verify the installation
Click Start Run Cmd.
Type the following command and press ENTER.
NET START MSSQLSERVER
Enter the following command to connect to MSSQLSERVER using the SQLCMD utility. Enter the following Transact-SQL commands to retrieve the server name:
Confirm that the server name is returned, and then enter the following command to exit the SQLCMD utility:
At the command prompt, enter the following command to stop the AWSQLSERVER2 instance:
NET STOP MSSQLSERVER
Close the command window.
Review the log files
Open Windows Explorer, and browse to the E:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG folder.
Double-click Summary.txt and review the contents of the file. Verify that setup succeeded with the installation.
In Windows Explorer, browse to the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files folder.
On the View menu, point to Arrange Icons by, and then click Type.
The installation wizard generates XML log files using the naming convention SQLSetup__Datastore.xml. You should open the file with the highest SetupID number, which relates to the most recent installation.
Find the most recent XMLlog file, and double-click the file.
In the Open With dialog box, click Internet Explorer, and then click OK.
Review the contents of the file, which detail the steps taken during the installation process. Note that the first section lists the checks made by the System Consistency Checker (SCC).
Close Internet Explorer, and then close Windows Explorer.