Hi all,

Sorry about the length of this, but we have a pretty
complicated issue and we are running out of ideas fast.

We have one adp.net c# code base that runs several MS CMS
web sites. They all use the same templates. These sites
live on two seperate W2k AS sp2 (MSCMS 2002, MS CS 2002)
web servers that are load balanced, and they both connect
to the same SQL Server machine. Now out of the 11 sites we
have all but one runs fine. The problem site only causes
the problem intermitantly. And fixing the problem is done
by replcaing the dlls on both servers.

heres the problem.
commerce server returns 3 'banners' to be displayed on the
homepage via the advertising functionality. After a given
period of time the banners are not returned, and we get an
invalid cast exception with error code 08004 - in SQL
Server this is 'server rejected connection'. However all
sites use the same connection string, and this problem
site dies work now and then. Once the failure occurs it
stays failed! Has anyone ever seen anything like this
before. The only difference is that this site passes a
different parameter on the profile object in order to get
different banners. But this is working fine - other wise
we would not see the site working at any point in time. We
are seeing a large number of current processes on the SQL
Server for this application, and worst of all we cant re-
produce this issue on the development environment!

Any ideas would be greatly appreciated

TIA

Adam Stewart

[ Post a follow-up to this message ]