Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors
I am unable to remote connect from my desktop using the VNN and port# to the named instance on non default port in the AOAG
Local connection tests - successful a) servername\instancename b)servername, port# c)server ip\instancename d)serverip, port# e)aoag listener\instancename f)aoaglistener, port# g)aoag listenerip\instancename h)aoaglistenerip, port#
Remote connection from desktop - successful if using server and instance names. But it fails if I try remote connection with VIP/VNN e)aoag listener\instancename f)aoaglistener, port# g)aoag listenerip\instancename h)aoaglistenerip, port#
I would like to use the separate AOAGlistener and port#s in the connection string.
I have validated -
- firewall rules work as tested from remote desktop using server ip and instancename/port#
- username password works
- using static ip and port#
- tcp is enabled and active/enabled are yes for each ip
- remote connectio is enabled.
Cannot connect to aoag_lsnr, 1551.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)
Server Name: aoag_lsnr, 1551 Error Number: 64 Severity: 20 State: 0
Thank you for your help.