Where have you created the cluster subnet IP, which node?

I have created cluster name in Primary datacenter servers in first node. And adding secondary datacenter different subnet IP while...

This is two IPs configured in cluster name..

As per this AO cluster setting not using shared disk SAN, NAS etc and Not configured quorum witness.

Due to 3 nodes participates....

I have verified by query select * from sys.server_principals, and that windows logins already exists.

USE [master]

GO

CREATE LOGIN [servername\sqladmin] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english],

GO

ALTER SERVER ROLE [sysadmin] ADD MEMBER [servername\sqladmin]

GO

SID=0x010500000000000515000000017CF23F899DF198F4C91586E9030000

Pl. correct...

Thanks for reply...

I checked at Error log

Message

Login failed for user 'Servername\sqladmin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

Message

Error: 18456, Severity: 14, State: 5.

It means...

Thank you anthony.green..

AM I correct as following condition.

1. Two nodes cluster with AO setup - it should be require to configure file share to another server for reading cluster resource...

Thanks a lot Mr. Anthony.green..

Created file share to another file server and configured NodeFileMajority in cluster.

Performed Tested as below

- It is working smoothly..just shutdown Node1 and...

Yes.. I am loosing quorum resource between two nodes...at first time I did not configure File share features during AO setup.

Is it mandatory to add 3rd node or just enable...

Yes.

Total 2 Nodes and AO configured these two nodes. There is no shared disk only local VHD. also not configured File share witness option.

Simulated AO setup.

1. Just stop the...

Yes. It is two nodes cluster configured in AO. No shared disk.

OS: Windows 2008 R2

DB: SQL Server 2012

Get-ClusterQuorum details

PS C:\Windows\system32> Get-ClusterQuorum -Cluster ClusterName

Cluster ...

Simulated AO setup.

1. Just stop the SQL Services in Node1 and connect AO Listener at client. It got connect and succeed - OK.

2. started Node1 SQL services and stop...

I red your stairway series 6..

There are two node FCI configured as below

Server Instance Node 1

Role - Primary

Availability Mode - synchronize

Failover Mode - Automatic

Connection in Primary Role - Allow...

Hi Perry Thanks for reply..

I studied some document internet both IPs are not be same.

1. Cluster IP unique IP - 10.xx.xxx.22

2. AG Listener unique IP - 10.xx.xxx.23

I Configured above...

I want to know, does cluster IP and Listener IP both are same? or should be entered different IP on both side in alwayson AG configuration?

thanks

Hello Mr. Perry..

What I am asking,

1. I should enter the unique IP address in access point administration portion while creating cluster group.

Application connection string which IP address to be...

Thanks for your replay..

I am not a developer. but I will try my best.

Could you give me any example for how will change existing nested cursor to set based...