15.3 Accessing an AlwaysOn failover cluster

15.3 Accessing an AlwaysOn failover cluster

15.3.1 Configuring SQL Server Instances

Similar to instances where the local computer is installed independently, instances of AlwaysOn failover clusters also need to be configured with SQL Server Configuration Manager.

In this example, an AlwaysOn failover cluster is installed as a named instance, so you need to configure its network protocols, enable SQL Server Browser, open firewall ports, and so on.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/3C/wKioL1V3ky7gqkM7AAQOu08WDvo467.jpg "title=" Sscm.png "alt=" Wkiol1v3ky7gqkm7aaqou08wdvo467.jpg "/>

15.3.2 Network Name

In the Active Directory users and computers and the DNS Management console, check the network name and IP address of the AlwaysOn failover cluster.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/3C/wKioL1V3k0WimmOVAAJrMZuc99k696.jpg "style=" float: none; "title=" Ad.png "alt=" Wkiol1v3k0wimmovaajrmzuc99k696.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/40/wKiom1V3kaCwVycQAAKi9MQyuRE522.jpg "style=" float: none; "title=" Dns.png "alt=" Wkiom1v3kacwvycqaaki9mqyure522.jpg "/>

15.3.3 from Client Access

If an AlwaysOn failover cluster instance is a default instance, the client directly accesses its virtual network name. In this example, an AlwaysOn failover cluster instance is a named instance, and is accessed by:< virtual network name >\< Instance name >.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/40/wKiom1V3k13CsoJhAAD7Ygfm_nk758.jpg "title=" Ssms.png "alt=" Wkiom1v3k13csojhaad7ygfm_nk758.jpg "/>

This article from "SQLServer2014 series" blog, declined reprint!

15.3 Accessing an AlwaysOn failover cluster