SQL Server 2000 Error 17805 Invalid buffer received from client

Hi,
I've developed an ASP.NET application which uses MS-SQL Server 2000 as a
backend. But as the site hits increase SQL server reponse becomes lower.
At some stage after that SQL Server gets automativally stopped bringing
complete web-application down to halt. i checked the Windows 2000 Event
Logs and found several error logs indicating folloowing line.
"SQL Server 2000 Error 17805 Invalid buffer received from client.". But
no errors on UI side. What may be the actual problem.In storedprocedures
or at some other place?

Awaiting favourble reply.

Regards,
Amit

*** Sent via Developersdex http://www.droptable.com ***

Amit Khatu  (amitkhatu@rediffmai
l.com)  writes:
> I've developed an ASP.NET application which uses MS-SQL Server 2000 as a
> backend. But as the site hits increase SQL server reponse becomes lower.
> At some stage after that SQL Server gets automativally stopped bringing
> complete web-application down to halt. i checked the Windows 2000 Event
> Logs and found several error logs indicating folloowing line.
> "SQL Server 2000 Error 17805 Invalid buffer received from client.". But
> no errors on UI side. What may be the actual problem.In storedprocedures
> or at some other place?

The message means that SQL Server received garbage on the wire. This could
be because of an error in the client API, or a netowrk problem. The
latter is much more likely.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp