Does anyone know of any current ADO/RDS issues that could cause a
connection to the database to fail? Any conflicts or problems with newer
patches/service packs/updates?

I have an application that has connectivity problems intermittently. It
clears itself up after 3-5 minutes. The issue can be duplicated by
shutting the SQL Server down.

If you have any advice or ideas please email me at
finucane@_REMOVE_algonquinstudios.com.

Thanks,

Timothy J. Finucane
Senior Programmer/Analyst
Algonquin Studios
http://www.algonquinstudios.com/

In article <vugkkakk1tv5b2@corp.supernews.com>, Tim
<speljamr@speljamr.com> writes
[quoted text, click to view]

If it looks like the server is not there, then it probably isn't as far
as the client is concerned, so I would start looking for network issues.
Pings, tracert's and simple osql or similar tests from the client, as
also other similar machines. Is it only one client or all clients etc.

One wild idea, check your SQL error logs as well in case you have some
AV or such like which causes the SQL Server to restart.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org