IIS Server Security - Urgent IIS + SQL (Not enough storage is available to complete this operation)

Author

Urgent IIS + SQL (Not enough storage is available to complete this operation)

tolgay

2006-07-21, 7:23 pm

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. The
server transaction is kind of high but there are several indexes so it not
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 there
is nothing also in sql server logs.

jas0n

2006-07-26, 7:27 pm

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. The server transaction is kind of high but there are
> several indexes so it not 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 there is nothing also in sql server logs.

We were seeing this problem and tracked ours back to a huge number of
active directory groups - we use the following in a .reg file to
increase the size - works ok after reboot then - it affected all sorts
of things - we couldnt add a pc to the domain without seeing this error.

Copy the following into notepad and save with name of your choosing,
ours in mtsize.reg then run it to make the change in the registry.

& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Control\Lsa\Kerberos\Parame
ters]
"MaxTokenSize"=dword:00010000