SQL AOAG
1 TopicSQL AOAG with listener ( without windows clustering)
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering). Steps done : 1. SQL installation done on 2 nodes 2. Service account is added as sysadmin on both servers 2. Enabled AOAG on both nodes 3. Database created & backup taken 4. Configuration of AG is done. Database added. Listener is created 5. SPN created in AD for the service account for both the nodes with server name and FQDN. Issue : Not able to connect via Listener in SSMS. Even it is not pinging ( error : Destination unreachable). However, it is providing IP address when NSlookup to listener name is done Any Suggestion.660Views0likes2Comments