Monday, October 20, 2014

3 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

3 comments:

  1. At Pay Someone To Do My Essay Uk we aspire to provide quality writing help services tailored to your specific needs, paired with brilliance infused in your work.

    ReplyDelete
  2. The author has discussed a very resourceful topic in times of the pandemic. We, as a nation, cannot keep our children out of schools forever. Hence a plan needs to be implemented where children can safely go to school without getting mass infected. However, it is not recommended for parents or children to go physically to the shops for book supplies. Hence there is a need for an online book shop such as KitaabNow.

    ReplyDelete
  3. I recently came upon your blog and wanted to express how much I liked reading your postings. I'm hoping you'll write again soon. Thank you very much for the excellent information. singapore import data

    ReplyDelete

 

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