SQL Server 2005 Tutorials
Tutorials SQL Server 2005Getting started with SQL Server 2005
Table of Contents
Getting started with SQL Server 2005 Getting started with SQL Server 2005 - Page 2 Getting started with SQL Server 2005 - Page 3Getting started with SQL Server 2005
Getting started and Installing SQL Server 2005
Microsoft has redesigned SQL server 2005 to deliver unprecedented value and functionality to the Database Administrator and the Developer. The four editions of the SQL server are Express, workgroup, Standard and Enterprise. Each of these editions offers a range of features.
High scalability, availability with advanced business intelligence tools empowers business users with a more secure, reliable and productive database management system. A reduced downtime and tight security controls make for a step forward in providing support to enterprise systems. Moreover, customers benefit from a reduced cost of ownership as this belongs to the Windows Server system.
In this tutorial we shall be installing SQL Server 2005 Enterprise Edition. However, before actually describing the installation process let us briefly examine the minimum requirements for installing and running SQL Server 2005.
Requirement for 32 bit platform
|
SQL Server 2005 (32-bit) |
Processor type |
Processor speed |
Memory (RAM) |
|
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition |
Pentium III compatible processor or higher required |
Minimum: 500 MHz Recommended: 1 GHz or higher |
Minimum: 512 MB Recommended: 1 GB or more Maximum: OS maximum |
|
SQL Server 2005 Workgroup Edition |
Pentium III compatible processor or higher required |
Minimum: 500 MHz Recommended: 1 GHz or higher |
Minimum: 512 MB Recommended: 1 GB or more Maximum: 3 GB |
|
SQL Server 2005 Express Edition |
Pentium III compatible processor or higher required |
Minimum: 500 MHz Recommended: 1 GHz or higher |
Minimum: 128 MB Recommended: 512 MB or more Maximum: 1 GB |
Requirement for the 64 bit platform
|
QL Server 2005 (64-bit) |
Processor type |
Processor speed |
Memory (RAM) |
|
SQL Server 2005 Enterprise Edition4 SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition |
IA64 minimum: Itanium processor or higher X64 minimum: AMD Opteron, AMD Athlon 64, Intel Xenon with Intel EM64T support, Intel Pentium IV with EM64T support |
IA64 minimum: 733 MHz IA64 recommended: 733 MHz or more X64 minimum: 1 GHz X64 recommended: 1 GHz or more |
IA64 minimum: 512 MB IA64 recommended: 1 GB or more IA64 maximum: 32 TB X64 minimum:512 MB X64 recommended: 1 GB or more X64 maximum: 32 TB |
Disk space requirements
|
Feature |
Disk space requirement |
|
Database Engine and data files, Replication, and Full-text Search |
150 MB |
|
Analysis Services and data files |
35 KB |
|
Reporting Services and Report Manager |
40 MB |
|
Notification Services engine components, client components, and rules components |
5 MB |
|
Integration Services |
9 MB |
|
Client Components |
12 MB |
|
Management Tools |
70 MB |
|
Development Tools |
20 MB |
|
SQL Server Books Online and SQL Server Mobile Books Online |
15 MB |
|
Samples and sample databases |
|
Other Requirements
|
Resolution |
1024 x 768 |
|
DVD Drive |
Required |
|
Cluster installations |
For 32 and 64 bit platforms eight node cluster installations required |
|
Operating System |
Windows Server 2003, Windows XP, Windows 2000, Windows 98 or Windows ME |
|
End points |
Introduces new concept of server connections called Transact SQL endpoint. |
|
Internet |
Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Management Studio, the Report Designer component of reporting services. |
|
Software Requirements |
Microsoft Windows Installer 3.0 |
|
|
Microsoft Windows .NET Framework 2.0 |
|
|
Reporting services require MDAC 2.8 on Windows 2000 |
|
|
SQLXML requires MDAC 2.6 or higher on Windows 2000 |
|
|
SQL Server Failover clusters require Microsoft Cluster Server (MSCS) on at least one node of the server cluster. |
The above list is by no means exhaustive but it does cover the fundamental requirements that need to be present while installing SQL Server 2005.
Now insert the DVD into the drive and begin the installation. The user is expected to read through the license agreement and accept the license before he can proceed any further. After accepting the license agreement click on Next to proceed.
Comments
Ritesh Aggarwal said:
|
:) Hi, it was very nice to go through such a useful information about the installation of the SQL Server. Howerver if more information could be provided about SQL Collations. Regards Ritesh Aggarwal |
Sajid Chhapekar said:
|
:) It is good to have in depth training on a topic which you want at a cost of none. |
chinna reddy said:
| this is the simple & good way for the installation of sql server 2005. |
scoloni said:
| so easy and detailed. thanks |
Yogesh. BN said:
| This is the simplest method and much easier to install SQL Sever 2005 .... i will appreciate the one who did this ..... |
omar said:
| realy useful information but i have one question, what's instant name important and job? |
Murali Mohan said:
| simple to understand and implement |
Khalifah Aslam said:
| Very good and easy explanation of SQL Server 2005 installation. |
Kiran Ganesh said:
| This inormation is very useful as they have explained reason for each step. |
ELPASO said:
|
Very good and easy explanation of SQL Server 2005 installation. |
Ramakrishna Melam said:
|
Very good and easy explanation of SQL Server 2005 installation. |
milindkale1 said:
| This Gives very clear understanding of installation of sql totally good description |
ShobhitPun said:
| I am a Oracle guy so didn't know ABCD of Sql Server...but this article was very helpful and simple to follow . Great work |
rony said:
| Thanks again for giving so nice explanation!!!!!!! |
Babatunde said:
|
This is a valuable information. It really simplify the installation and easy to follow Merci, Gracios, Thank you |
Javed Ahmad said:
| I am student and see your instruction for installation. it is good for beginner. thanks lot |
jemmy said:
| very good ...information |
Thirumala Reddy said:
| Simply super to understand without knowing SQL Server |
jhony said:
| very good information...ThanQ |
Hector said:
| Its good to know that there are website yhat are so informative as yours. |
vinod k said:
| this is simple method, very good |
pramod said:
| it is user friendly. |
Dewey said:
| Nice job! Do you have the sql2008 ready? |
Weekly Offers
Sponsored Links
Partners | Privacy and Legal Policy | Site News | Contact | Site Map
Copyright © 2000 - 2008 exforsys.com. All Rights Reserved
