🚀 go-pugleaf

I chose the Windows NT security option on my SQL 7.0 database, which I
am testing and have not yet put into production use, and am sometimes
getting an error that says:

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'IRP\USR_IRPSERVER'.

The name of my domain is IRP and the name of my server is IRPSERVER.
The error occurs after I have navigated quite a bit from one
active-server page to another.  When I first enter the database, after
logging in via the Windows NT security dialog box, everything works fine

at first.  Then, as the number of navigations from one ASP page to
another increases, the error starts to appear.  At first, I can get rid
of the error by reloading my browser screen.  Later, the error gets so
pervasive that none of the ASP forms will load at all.  After I get off
the system for an long time, things are back to normal until I navigate
a large number of times again.  It almost seems like some kind of memory

problem.  I tried increasing the "reserve physical memory" setting under

enterprise manager to 32 MB, and this seemed to help--it seemingly takes

longer for the problem to occur, but it eventually does occur.

Does anyone know what might be happening and how I might solve this
problem?

Joe Meyer, Director
Institutional Research
Southwest Texas State University