Hi there! I have an ESX 2.5.3 (build 22981) VMWare installation running, among other things, a SQL Server 2005 under Windows Server 2003 Enterprise. Periodically, at what seems to be random (un-logged) intervals, the SQL Server "loses" various client connections. Just disconnects them, regardless of KeepAlive settings (which I moved from 30,000 down to 10,000).
Things could be complicated by the fact that the Client software is a hokey Accounting package written using MS Access 2K3 as a front end, but connecting to SQL Server for data. But I'm not too sure that Access is to blame, this time - it appears that the common problem is the (Virtualized) SQL Server.
Before we virutalized everything, and the SQL Server/2K3 Server were "metal", this did not occur. Searching VMWare's KBs have shed literally no light here, and Microsoft's documentation seems to think that by setting the KeepAlive to a shorter interval will resolve the problem - which it hasn't.
I am aware and have studied <http://blogs.msdn.com/sql_protocols/archive/2006/03/09/546852.aspx
> and <http://support.microsoft.com/kb/137983/?sd=RMVP&fr=1
>, neither of which seem to help. And my users, while patient, are curious to see if we might de-virutalize this server - if that will help their connectivity issues.
Any ideas what to check? I'm admittedly a noob when it comes to VMWare - I love it, but I'm not sure I know enough to get the most out of it.
Thanks (in advance) for your time and trouble,
- The Lurking LongFist