I dropped an AG with
DROP AVAILABILITY GROUP [MyDb]
it had a listener.
I left the listener open in the object Explorer of SSMS 17.3. While the AG and Listener were down. I hit refresh on the listener a couple times in SSMS. (because I have OCD and had to make sure it was gone)
I recreated the AG with the same listener and when I hit refresh it would not connect. I get the message below. I tried the following and was not able to connect, receiving the same error.
I was able to connect using the fully qualified domain name 'MyListener.fully.domain.net', but was still unable to connect with just 'MyListener'
A coworker was able to connect to the listener without issue, using both 'MyListener' and 'MyListener.fully.domain.net'
I rebooted my Windows 10 PC, and after reopening SSMS I was able to connect with just the listener name 'MyListener'.
I upgraded SSMS to 17.4 and the same thing happens.
What is happening here? How can clear the issue without rebooting my PC?
TITLE: Connect to Server
Cannot connect to MyListener.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
The network path was not found
Note in all cases I created the AG and added the listener using a variation of the T-SQL from https://www.brentozar.com/archive/2016/06/sql-server-2016-availability-groups-direct-seeding/ The AG is on an instance running SQL Server 2016 RTM, the database is AdventureWorks2014.