In my previous post; We have learnt how to install Windows Server 2008 R2 Failover Cluster. Reivew from this link
to Setup SQL Cluster we need to install SQL Server 2012.
SQL Server 2012 Installation
You
can install standalone SQL server 2012 on both nodes that are ready for cluster
setup or you can install it using single cluster node wizard. Microsoft .Net
framework 3.5 or above needs to be installed on VMs. I will perform standalone
here, cluster node installation require share disk to be install and I am doing
this on share folder, that’s why I am unable to install SQL server using single
cluster node installation.
Needs to add feature
from windows features
Start SQL Server
installation this is Enterprise setup
SQL
Server 2012 install updates if required. Internet connection is required
If there is any
error or warning message i.e firewall is enabled, allow proper ports or disable
firewall
Select
appropriate features that are required to install for always on feature.
Features are
- SQL Server setup
- Network Name,
- IP Address,
- Shared disk or nodes,
- Database Engine,
- Agent Service,
- Analysis Services if installed,
- One file share resource, if FILESTREAM feature is installed.
Along with database
engine, analysis services service will be installed
Changed database
engine service account from [NT Service] user to the domain user i.e SQL .
Otherwise it will generate error while you are configuring always group through
wizard.
Mix user mode
selected
SQL Server 2012
successfully installed. Please install it on both nodes to complete SQL Server Always On availability Group.
In Next Step
No comments:
Post a Comment