You might want to seriously look at putting IIS on its own server - trying t
o
run both IIS and SQL Server on the same machine can cause phantom issues to
arise - are you running ASP or ASP.NET applications on the server?

"tolgay" wrote:

> Sometimes we got an error (Not enough storage is available to complete
>  this
>  operation) from one of our servers which on win2000 sp 4 iis5.0 (all
>  hotfix
>  installed) sql server sp4. mdac 2.81. It occures random and we could not
>  find the error reason. When the error occured the server cpu or mem or I/
O
>  usage is normal and I try to find out from internet and some says check
>  the
>  mdac verision registery size or oracle etc. they do not indicate our
>  problem.  we use adodb connection to connect sql server and all of them
>  close after the proccess also all recordset are close and set nothing. Th
e
>  server transaction is kind of high but there are several indexes so it no
t
>  seems a problem there. When IIS restarts the problem solves but all users
>  sesions are closed. Have you ever met the error before or what can be
>  problem. Any advice would be helpful
>
>  There is nothing in to event log even a warning also temp db size quite
> large and the db transaction log is about 2 gbyte and %75 is free and ther
e
>  is nothing also in sql server logs.
>
>
>
>

[ Post a follow-up to this message ]