Monday, October 20, 2014

0 SQL2014: Create two nodes SQL Server 2014 AlwaysOn Failover Cluster Instance

This is the my note to install SQL Server 2014 on the Cluster.

prerequisites

Build windows failover cluster : Please refer here.

Install SQL Server 2014 on the node 1

select the New SQL server failover cluster installation

image

image

Ignore MSDTC clustered warming and .Net security . You may want to fix the network binding order.image

The SQL Server binary is installed on the local drive . ( C )

image

Select the SQL Server Network Name

image

SQK Server Cluster Resource Name

image

Select installation disk

image

choice the IP address. this IP address can not be the same as any existing one.

image

image

image

image

image

image

image

Reboot the node, you may want to failover the cluster resource back to N1 before proceed the next installation.

Add a node to an existing SQL Server clustered instance on the node 2

Even the BOL says we can use double quote “” and single quote ‘’, per my testing, it has to be double quote.

setup.exe /action=addnode /UpdateEnabled=0 /INSTANCENAME="SQL2014SGC6" /SQLSVCACCOUNT="STARGATE\sqlprodid" /SQLSVCPASSWORD="XXXX" /AGTSVCACCOUNT="STARGATE\sqlprodid" /AGTSVCPASSWORD="XXXX" /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS

This installation is not silent install, we will still see the GUI .

image

image

image

image

image

image

Test SQL Server connectivity

Connect to SQL Server through [HOSTNAME]\[INSTANCE NAME], In this case SQL2014C1\SQL2014SGC6

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1;
GO
-- To update the currently configured value for advanced options.
RECONFIGURE;
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1;
GO
-- To update the currently configured value for this feature.
RECONFIGURE;
GO
SELECT
            SERVERPROPERTY('MachineName') AS [ServerName], 
            SERVERPROPERTY('ServerName') AS [ServerInstanceName], 
            SERVERPROPERTY('InstanceName') AS [Instance], 
            SERVERPROPERTY('Edition') AS [Edition],
            SERVERPROPERTY('ProductVersion') AS [ProductVersion], 
            Left(@@Version, Charindex('-', @@version) - 2) As VersionName,
            SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
GO
xp_cmdshell 'hostname'

image

Manually failover

image

image

image

The ComputerNamePhysicalNetBIOS change from SGC6 to SGC7 .

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates