SQL SERVER

INSTALLATION

AND

CONFIGURATION

What is a SQL Server?

used to manage and store

information.

“relational database management

system” (RDMS).

SQL Server Editions and

Version

1. Express Edition:

- Designed for easy deployment and rapid prototyping, and

- performance for embedded application clients, light web

applications, and local data stores.

2. Workgroup Edition:

- designed to provide basic relational database services for

departments and branch offices.

- It supports a maximum of 2 CPUs, 4GB of RAM, andunlimited database size.

- Its only BI feature is Reporting Services.

3. Standard Edition:

- Designed for small and medium businesses, the Standardedition supports up to 4 CPUs and 2TB of RAM,

- with unlimited database size. It includes support for all BIsubsystems including Analysis Services, Integration Services,and Reporting Services, but lacks many of the enterprise-oriented features from the Enterprise edition.

4. Enterprise (Developer) Edition:

- Enterprise for mission critical applications,

- This is the high-end edition, with the advancedperformance and availability features (e.g., tablepartitioning, data compression) required to supportthousands of connections and databases measured byterabytes.

The Developer Edition is the same as the EnterpriseEdition, but it’s licensed only for development andtesting and it can run on workstation versions ofWindows.

Continued..

5. Datacenter edition:

- More power than all other

editions.

- It costs more compare to others.

- It has all features of enterprise

edition and supports all data

related features.

SQL Server edition comparison

SQL Server edition comparison

Service accounts

The SQL Server services require Windows login accounts

to run and access the file system. It’s possible to allow SQL

Server to run using the local service account, but

creating a specific Windows user account for SQL Server

services provides better security and reliability.

You can configure these accounts with the requiredminimum set of permissions (user, not administrator) and

access to the data files.

The accounts can be specified independently during

installation by selecting the ‘‘Customize for each service

account’’ option. By default, SQL Server, SQL Server

Agent, Analysis Server, and SQL Browser share the same

login account.

The default location for SQL Server and associated files

will be similar to the following: “C:\ProgramFiles\Microsoft SQL Server\MSSQL.#”.

Service Packs, Hot fix,

Cumulative Updates

Service Packs: An update to a software version

that fixes an existing problem, such as a bug,

or provides enhancements to the product that

will appear in the next version of the product.

When the new product version is released, it

usually contains the fixes and updates from the

service pack. Service packs can either be

downloaded or ordered directly from the

company.

HotFix: is when of something happening

quickly or proactive solution.

- applied without stopping or restarting a service

or system.

Continued..

Cumulative Updates:

- provides hotfix releases on

a scheduled delivery basis

for Office Server products.

- deliver high-quality fixes on

a predictable schedule.

SQL Server installation-Hardware/Software Requirements:

o NET Framework 3.5

o SQL Server Native Client

o SQL Server Setup support files

o Windows service pack

o Processor :

Processor type: Minimum: 1.0 GHz,

Recommended: 2.0 GHz or faster

RAM 512 MB & Recommended: 2.048

GB or more

Pre-installation

We need to have Service account for all

sql services that needs to be installed.

(we get this from Windows team)

Make sure we have administrator

privilege for the service accounts.

Make sure we installed .Net Framework

and windows installer.

Need to have the software

For clustered servers we should have IP

addresses.

Performing the Installation

Setup.exe opens the SQL

Server Installation Center,

which brings together into one

UI a broad collection of

installation utilities and

resources --- from the planning

stage to advanced options.

Post-Installation

Apply latest service packs

Configure TCP ports to default value 1433

Enable named pipes.

Allocate maximum memory size for sql server to

use.

Creating monitoring jobs, backup jobs,

maintenance plans,…

Creating alerts, Operators

Configuring database mail

Performing QA checklist

Removing SQL Server

(decommissioning)

To remove SQL Server, use the Add/Remove Programs optionin the Windows Control Panel. If there are multiple instances,removing a single instance will leave the other instancesintact and able to function.

User databases will not be deleted by the uninstall and theirdirectory structure remains intact.

Detaching and copying a database to another server priorto removing an instance of SQL Server enables continuedaccess to the data. If that is not possible, back up andrestore the database to another server or attach theorphaned database to another server.