SQL Server 2005 có nhiều phiên bản khác nhau, trong đó bản Express là bản thấp nhất, được Microsoft cung cấp miễn phí cho người dùng với mục đích học tập và ứng dụng vào những ứng dụng nhỏ, không yêu cầu cao về các tính năng khác ngoài việc lưu trữ và xử lý đơn giản.
Yêu cầu về phần cứng và hệ điều hành sử dụng
Yêu cầu về phần cứng và hệ điều hành sử dụng
- Hệ điều hành tối thiểu: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2
Phần cứng:
- Máy tính chip Pentium III 600 MHz trở lên (Cấu hình đề nghị: Chip 1 GHz hoặc cao hơn.)
- Tối thiểu 192 MB RAM (Cấu hình đề nghị: 512 MB RAM.)
- Ổ cứng còn trống tối thiểu 525 MB
ENG: SQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications. SQL Server 2005 delivers powerful, familiar tools to IT professionals as well as to information workers, reducing the complexity of creating, deploying, managing, and using enterprise data and analytical applications on platforms ranging from mobile devices to enterprise data systems. Through a comprehensive feature set, interoperability with existing systems, and automation of routine tasks, SQL Server 2005 provides a complete data solution for enterprises of all sizes. Figure 1 shows the layout of the SQL Server 2005 data platform.
SQL Server 2005 advances your data infrastructure in three key areas: it makes your enterprise data more manageable, your developers more productive, and your business intelligence (BI) more comprehensive. It also breaks new ground in affordable pricing and licensing, upgrade paths to SQL Server 2005, and the Microsoft Windows Server System.
Your organization today faces numerous data challenges. You need your people to make faster and more data-driven decisions, your developers to be more productive and flexible, and your managers to reduce their overall information technology (IT) budgets even as they scale your infrastructure to meet ever-increasing demands.
AQL Server 2005 is designed to help enterprises address these challenges. This next-generation data management and analysis solution delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.
Extending the strengths of SQL Server 2000, SQL Server 2005 provides an integrated data management and analysis solution that can help your staff do the following:
- Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable.
- Maximize IT productivity by reducing the complexity of developing and supporting database applications.
- Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.
- Control costs without sacrificing performance, availability, scalability, or security.
SQL Server 2005 advances your data infrastructure in three key areas: it makes your enterprise data more manageable, your developers more productive, and your business intelligence (BI) more comprehensive. It also breaks new ground in affordable pricing and licensing, upgrade paths to SQL Server 2005, and the Microsoft Windows Server System.
Your organization today faces numerous data challenges. You need your people to make faster and more data-driven decisions, your developers to be more productive and flexible, and your managers to reduce their overall information technology (IT) budgets even as they scale your infrastructure to meet ever-increasing demands.
AQL Server 2005 is designed to help enterprises address these challenges. This next-generation data management and analysis solution delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.
Extending the strengths of SQL Server 2000, SQL Server 2005 provides an integrated data management and analysis solution that can help your staff do the following:
- Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable.
- Maximize IT productivity by reducing the complexity of developing and supporting database applications.
- Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.
- Control costs without sacrificing performance, availability, scalability, or security.
for 32bit
for 64 bit
Hướng Dẫn Cài Đặt Microsoft SQL Server 2005 Enterprise
I.Chuẩn bị cài đặt SQL Server 2005: SQL Server 2005 EditionDescription Enterprise Edition (Available in 32-bit and 64-bit versions)
A comprehensive edition of SQL Server engineered for extremely high levels of scalability and performance. Use this edition for large-scale, enterprise-level, mission-critical applications.The Enterprise Edition contains all the features of the Standard Edition, as well as enterprise features, including:• Failover clustering• Database mirroring• Snapshot databases• Mirrored backups• Online page and file restore• Distributed partitioned views• Heterogeneous replication• Peer-to-peer replicationStandard Edition (Available in 32-bit and 64-bit versions)Engineered for workgroup or department-level applications. Use this edition if you do not need the levels of scalability, performance, and availability offered by Enterprise Edition.Express Edition (Available in 32-bit version only)A version of SQL Server 2005 for disconnected clients or stand-alone applications.Developer Edition(Available in 32-bit and 64-bit versions)
Includes all of the functionality of Enterprise Edition, but is licensed for use as a development and test system, not as a production server. Use this edition to develop and test database solutions.This edition can be upgraded to Enterprise Edition for production use.II.Yêu cầu phần cứng: Processor requirements
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. Memory requirements
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
Additional hardware requirements for typical installation scenarios include:§Monitor (SQL Server administrative tools are optimized for a screen resolution of 1024 x 786)§Pointing device§Network adapter§CD / DVD drive (for installation from CD) III.Yêu cầu hệ điều hành:
Chú ý phiên bản Enterprice chỉ setup trên Window server
IV.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.
Tại đây có 2 tuỳ chọn: Nếu chúng ta chừng thực bằng tài khoản user local SQL sẽ lấy tài khoản chính máy local cua chúng ta để đăng nhập. Thứ 2 chúng ta chúng thực bằng tài khoản SA(mặc định) và đặt Pass
Chọn
để khởi động lại server.
V.Verify the installation Va Start à Run à Cmd.NET START MSSQLSERVER
A comprehensive edition of SQL Server engineered for extremely high levels of scalability and performance. Use this edition for large-scale, enterprise-level, mission-critical applications.The Enterprise Edition contains all the features of the Standard Edition, as well as enterprise features, including:• Failover clustering• Database mirroring• Snapshot databases• Mirrored backups• Online page and file restore• Distributed partitioned views• Heterogeneous replication• Peer-to-peer replicationStandard Edition (Available in 32-bit and 64-bit versions)Engineered for workgroup or department-level applications. Use this edition if you do not need the levels of scalability, performance, and availability offered by Enterprise Edition.Express Edition (Available in 32-bit version only)A version of SQL Server 2005 for disconnected clients or stand-alone applications.Developer Edition(Available in 32-bit and 64-bit versions)
Includes all of the functionality of Enterprise Edition, but is licensed for use as a development and test system, not as a production server. Use this edition to develop and test database solutions.This edition can be upgraded to Enterprise Edition for production use.II.Yêu cầu phần cứng: Processor requirements
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. Memory requirements
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
Additional hardware requirements for typical installation scenarios include:§Monitor (SQL Server administrative tools are optimized for a screen resolution of 1024 x 786)§Pointing device§Network adapter§CD / DVD drive (for installation from CD) III.Yêu cầu hệ điều hành:
Chú ý phiên bản Enterprice chỉ setup trên Window server
IV.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.
Tại đây có 2 tuỳ chọn: Nếu chúng ta chừng thực bằng tài khoản user local SQL sẽ lấy tài khoản chính máy local cua chúng ta để đăng nhập. Thứ 2 chúng ta chúng thực bằng tài khoản SA(mặc định) và đặt Pass
Chọn
để khởi động lại server.V.Verify the installation Va Start à Run à Cmd.NET START MSSQLSERVER
No comments:
Post a Comment
Cảm ơn bạn đã ghé thăm blog. Bạn thấy bài viết này như thế nào?