Dear Friends, We are facing issue with SQL Server 2012 Availability Groups Listener. Please find below details. Two server with Windows Sever 2008 R2 Enterprise - Clustering Services
1) Server A (Physical Server) --> SQL Server 2012 2) Server B (VM Server from VMWare) --> SQL Server 2012 We have two groups AG Groups.
1) AGMain (LISNERMain, 192.168.111.XXX,1433) --> Primary on A, Secondary on B 2) AGReports (LISNERReport, 192.168.111.XXX,1433) --> Primary on B, Secondary on A When we use Listener in connection string in our application, In some case of DataReader connection will close & throw below error. **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: TCP Provider, error: 0 - The semaphore timeout period has expired.)** If we use server IP with same scenario, It works..when we use Listener..randomly it throw above error. Connection string : "user id=sa; password=pwd; Initial Catalog=DBNAME;Data Source=LISNERMain,1433;enlist=false;MultiSubnetFailover=True;MultipleActiveResultSets=True;Connect Timeout=15;Max Pool Size=200;"