The following sections walk you through a typical installation scenario step by step. We bring up important points of information along the way, providing a real-world perspective on the process. No past experience with SQL Server is required to understand these sectionsNetwork Protocol Support
The following network protocols are supported for all editions (where applicable):
To explain the few terms
This is the simplest protocol of all the other protocols available in SQL Server. The limitation is that the client applications must reside on the same machine where the SQL Server is installed.
This protocol can be used when your application and SQL Server resides on a local area network. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).
This is the most popular and common protocol widely used throughout the industry today. It communicates across interconnected networks and is a standard for routing network traffics and offers advanced security features.
(DEPRECATED) DO NOT USE
Virtual Interface Adapter (VIA) protocol works with VIA hardware. This protocol has been deprecated and will no longer be available in the future versions of SQL Server.
Running Multiple Simultaneous Editions
You can install multiple editions of SQL Server 2008 on the same machine and run them simultaneously. This capability comes in handy when you need to test code or other feature functionality on one edition versus another, such as when your development and deployment environments differ. In fact, you can even install and run SQL Server 2008 Enterprise Evaluation Edition on XP SP2 (not supported for the non–Evaluation Enterprise Edition) if you need to test an Enterprise Edition feature on a non–Windows Server system.
You can quickly ascertain the SQL Server edition you’re running by executing this T-SQL query:
The following sections walk you through a typical installation scenario step by step. We bring up important points of information along the way, providing a real-world perspective on the process. No past experience with SQL Server is required to understand these sections.
SQL Server 2008 is actually version 10 of the product, just as SQL Server 2005 is version 9, and SQL Server 2000 was version 8, which succeeded SQL Server 7. SQL Server 2008 R2 is considered version 10.5. Although versioning by year seems straightforward, it may obfuscate the reasoning behind the naming convention used for many installed items, such as shared folder names (for example, Microsoft SQL Server\100), SQL Server instance folder names (for example, \MSSQL10_50.MSSQLSERVER), and so on. In addition, SQL Server 2000 servers appear as version 8 when registered in SSMS (and elsewhere). You can still administer many aspects of SQL Server 2000 instances via the 2008 and 2008 R2 management tools.
The following software prerequisites must be installed on any server running any SQL Server edition:
The following is the software and operating system requirements for SQL Server 2008, by edition.
Licensing for multicore processors is the same as for single-core processors: only a single license is required for each multicore processor. Another way of saying this is licensing is per CPU socket, not per processor core.
The following is space requirements for SQL Server installing
Online sql dba learning
Installing SQL Server is the first and one of the easiest tasks you’ll accomplish as an administrator. And even though it may take as little as 15 minutes to get SQL Server 2008 up and running by clicking through the install screens and accepting the defaults (Next, Next, Next...), it is crucial to first understand the meaning of each install option and its ramifications for your environment.
What’s New in Installing SQL Server 2008
The installation process has been completely revamped for SQL Server 2008, introducing enhancements to simplify the installation compared to SQL Server 2005. The new installation features for SQL Server 2008 include the following:
With the release of Service Pack 1, SQL Server 2008 also now supports Slipstream installation. Slipstreaming is a method of integrating a SQL Server 2008 update (such as a service pack or cumulative update) with the original installation media so that the original media and update are installed at the same time. This capability can be a huge timesaver over having to manually apply service packs or cumulative updates after performing a full installation.
Before you install SQL Server 2008 on your server, it’s a good idea (even if you own the latest-and-greatest system) to review the hardware and software requirements. The next two sections gather all the fine print into a few conveniently organized tables.
The SQL Server 2008 installer helps determine whether your system meets the minimum requirements by running the new System Configuration Checker (SCC) early in the install. SCC conveniently provides a savable (via a button click) textual report on its results (and displays them onscreen). SCC is covered in detail later in this page.
To install SQL Server 2008, you must ensure your system possesses a few basic components:
The below lists server environment hardware requirements, by SQL Server edition, with reference to processor type and/or word length. This table lists the base minimum hardware requirements. In most installations, you want to have at least 2GB of memory and a 2GHz or faster processor. In addition, installation using a redundant array of disks (RAID) on production systems is highly recommended.
Of course, faster editions of processors, increased RAM, and more disk space don’t negatively impact any installation either. One final (and perhaps obvious) note: The more SQL Server components you install, the more disk space you need. Analysis Services, for example, requires an additional 90MB of disk space for the install.The hard disk space requirements for SQL Server are dependent on which SQL Server components are installed.
The following is Hardware requirements for installing SQL Server
SQL DBA School is strongly committed to providing complete practical training exclusively on Microsoft SQL Server and Datawarehousing technologies. SQL DBA School Training Institute established in February 2013 is now one of the best training institute offering SQL Server and T-SQL (SQL Server) Training, SQL Database Administration (SQL DBA) Training and Business Intelligence (MSBI / SQL BI) Training.
We have been working with numerous consultancies in USA & UK. We undertake training on SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 versions. We make sure that all our sessions are very much interactive and well structured with doubts clarifications during and after each course.
"An education equips a mind. A degree demonstrates its potential."
- IGNATIUS J. REILLY
"SQL DBA School presented me with all of the opportunities I needed to succeed."
- GEORGE BOWLING
"The sense of accomplishment I felt after completing my SQL DBA School courses was great!"
- TIM DOYLE