Forum Discussion

jainChetan's avatar
jainChetan
Copper Contributor
Dec 06, 2023

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

SQL AOAG

2 Replies

Sort By
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Dec 07, 2023

     

    Even it is not pinging ( error : Destination unreachable).

    jainChetan , a Ping is on OS/Network layer level.

    If even that is not working, then your complete Windows OS is already not working; SQL Server sits only on top of the system.

    • jainChetan's avatar
      jainChetan
      Copper Contributor
      Dec 10, 2023

      Both Listener (X.26.92.8) and Server IP (XX.26.92.6)are in same VLN then ideally communication should be allowed within vLan,
      I got that also checked with my network team and they are saying the same.
      Now, what should be next step of troubleshooting

       

      Snap of the error when trying to login via listener name

       

Resources