x

AlwaysOn Availability Group listener

Hi,

We are using .NET 4.0 and (SQL SERVER 2012) AlwaysOn Availability Group Listener for Connection and getting below error.

Exception occured while using ExecuteReader,

DbConnectionPool, GetConnection,

  • 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.)*

Thanks & Regards

more ▼

asked Jul 09, 2013 at 01:14 PM in Default

avatar image

haresh.makwana
80 6 7 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Is this a new AG (Availability Group) or an existing SQL box that has been up for awhile. Are there any other connections from the source server to this SQL instance or a new connection? If a new connection, validate that proper ports are open in the firewall. You can validate this by using telnet to connect to the SQL instance. If the telnet client is on your server, open a command prompt and type telnet ip_of_server port_number. For example "telnet 127.0.0.1 1433"

Are you trying to connect via IP or DNS name, ensure the DNS name resolves properly as well if you are using DNS name.

more ▼

answered Jul 09, 2013 at 01:24 PM

avatar image

Tim
40.9k 39 92 168

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x398

asked: Jul 09, 2013 at 01:14 PM

Seen: 1021 times

Last Updated: Jul 09, 2013 at 03:34 PM

Copyright 2017 Redgate Software. Privacy Policy