There were memory physical dump details logged in the error log just before login failures started.

It doesn't seem so. Is it anyway possible that it could be due to memory issue? I know its something unusual to ask but need to go thru all possibilities.

Thanks.

No, all SQL accounts were created on different dates.

Thanks for the reply but how come all accounts on that instance were expiring at the same time. I want to know could this happen due to memory pressure or...

Yes domain account with admin rights. This has been resolved now. We have applied slipstream setup after uninstalling it. Thanks.

Any workaround on this?

It took around 8 hours to become normal. I dont think in a production environment, we can afford this much downtime. Is it a bug or anyway realted due to...

There is requirement to track who is accessing which view and at what time. There are numerous views in databases in SQL 2000 instance which fetches confidential data. DB Owner...