Resolved issues.. listener created successfully after giving proper permission in AD side.

this Listener object must be added in cluster computer object security permissions with full rights

Thanks

Thanks for your valuable reply..

In AD team shows to me, that Pre-staged Listener name object and domain account having FULL Control defined in AD level even same problem coming.

Pl. guide...

I tried again manually move to cluster resource to DR datacenter in another subnet IP.

Select Cluster name-> select More action-> select Move Core Cluster Resource -> Select Node - choose...

I have checked manually that second IPs. it is not bring online.

1. First IP to bring offline then cluster name and first IP become a offline.

2. Then bring second IP...

Attached screen shots Cluster core resource

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...