Whenever we want to start the installation of the SQL server we need to gather details of installation.
|Sql server 2014 (Heteko)||Trail version released|
|Sql server 2012 (Denali)||11.002100.60||11.00.3000|
|Sql server 2008 R2 (Kilimanjaro)||10.50.1600||10.50.2500||10.50.4000|
|Sql server 2008 (Katmai)||10||10.00.2531||10.00.4000||10.00.5500|
|Sql server 2005 (Yukon)||9.00.1399.06||9.00.2047||9.00.3042||9.00.4035||9.00.5000|
|Sql server 2000(Shiloh)||8.00.194||8.00.384||8.00.532||8.00.760||8.00.2039|
|Sql Server 7.0 (Sphinx)||7.00.623||7.00.699||7.00.842||7.00.961||7.00.1063|
Editions available in SQL server
Express and evaluation edition falls under free editions one is free of coot and evaluation expires after 180 days no need to buy licenses from Microsoft.
SQL Server Special Editions: Special editions are web edition for web developers, developer edition for designing stored proc and exclusive for developing purpose.
Workgroup edition for small scale industries: We do not use free and special editions in production servers we use mainly enterprise edition.
Windows admin will perform this installation and provides the server to SQL DBA to perform SQL installation Microsoft recommends to get complete enhanced features of SQL server use the same windows operating system.
Example: SQL server 2012 provides the best performance with windows server 2012. Most SQL server components integrated with windows operating only.
Components to be Selected
SQL Server mainly depends on services.
The instance is the name of the server. It is a logical SQL server. For the first time, if we execute SQL server setup, the installation uses the windows registered name that we called default Instance.
Named instances, if we run SQL server setup again a new SQL server will be created to work. Each and every time it creates multiple instances. Only one default instance will be there on the server. Named instance depends on SQL server. In SQL Server 2012 it supports instances.
Whenever we install SQL server it will create new binary files or each installation shared components like management studio, business intelligence studio and other features will install only once.
By default, SQL Server installation creates a set of files in c:\program files\microsoft\sql server. If we want to change the path we can keep them on E (or) G drive.
SQL Server by default uses character set and sort order common keys on the keyboard that is going to support by default it uses.
The process of validating login account is authentication. We have 2 types,
It allows only windows logins which are stored in active directory. SQL Server uses the same account for connecting mixed-mode authentication.
It allows window login and SQL server login. Whenever login tries to connect first it validates in the active directory if not found them comes to system logins for validating if found establishes the connection.
Services used for better control on sql server one program may have multiple services. Enter sql server run using these services. We have,
If this service is running. SQL Server will run most important service. All other 4 services depend on this service. DB engine run under influence of sql server service.
Entire automation process run under this service. agent service will look at scheduled time of jobs and invoke tasks automatically.
In the Production service, this service will be disabled due to security reasons.
We keep most repeated words in the catalog for faster search of data from the database
Microsoft distribution transaction coordinator is useful for handling distributed transactions from other servers.
Before installing the SQL server, the server needs the following prerequisites.
SQL Server 2012 installation is almost the same as the SQL server 2008 menu of SQL Server installation center. Planning, Installation, Maintenance, Tools, Resources, Advanced, and Options
Planning helps in reviewing
Planning various hardware and software requirements of the server. System configuration checker (SCC) scans the machine where the installation of the SQL server exists and provides results that to avoid obstacles while installing an upgrade advisor will help while upgrading.
The installation provides various installation options
We can install a new SQL server for the first time (or) we can add additional features to an existing installation.
We can upgrade and repair the SQL server from here.
System configuration checker scans SQL server installation. Installed SQL features provide detailed reports about SQL products installed on the server.
Upgrade integration packages is a wizard step in upgrading lower version SSIS packages to SQL server 2012 packages
Resources will help in knowledge on SQL server 2012
Configuration file installs configuration files on the existing file.
The advanced cluster provides wizards for failover clustering. Image preparation gives install methods in SQL server 2012.
In option, we can specify the architecture of SQL server install (or) to change location of install files.
Once all these details provided we can start the actual installation
The installation process starts with system checks and validations setup role is new screen in SQL server 2012, to choose install all features with default settings.
SQL Server 2012 installation completed
1. Verify protocols enables (or) not
Microsoft sql server 2012 — sql server configuration manager — sql server network configuration — protocols for MS sql server
2. Open services in sql server configuration manager select sql services and verify whether they are started (or) not.
3. From run command type services .msc and verify the ms sql services status and mode.
4. Verify the advanced options using
Sp_configure “show advanced option” 1
Go and reconfigure
5. Specify maximum and minimum server memory
Sp_configure ‘max server memory (MB), 8192;
Sp_configure ‘Min server memory (MB), 1024;
6. Enable backup compression, if we want
sp_configure ‘backup compression default’ 1
Reconfigure with override
#Ref. Ram Mohan & Rama Krishna notes