I'm not suggesting that this is llblgen issue. But probably you guys have deal with this or sort of. I'm using LLBLGEN 3.5 Self servicing. Can you give some advice.
Scenario
•.NET 4.0 Console applications IP X.XXX.XXX.XX Communicate with SQL SERVER 2008 R2 IP Z.ZZZ.ZZZ.ZZ
•Both server are Inside DMZ
•Error Message "
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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
"
•Port 1433 is confirm open on XX & ZZ
•Application randomly lost connection with the sql. Error Message above.
•Most of the time connection is success.
•Same applications are working properly with out any issue on separate environment.
Things Done So far with out success.
•Increase windows tcpip Max pool
•Turn of all firewall between them
•Change Increase Max Pool on Console; Pool = true; Application connection string
•Monitoring packages between server.
•No network issue is detected
•No communication problem between both server
•Network TCPIP Enable. IPV6 Enable
Theory & +
•Tcpip pooling is closing connection after multiple connection
URL Reviewed
•http://social.msdn.microsoft.com/Forums/sqlserver/en-US/42b1d5c3-ad7a-40f4-8af7-56c61c4baa3f/random-error-a-networkrelated-or-instancespecific-error-occurred-while-establishing-a-connection
•http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/
