caching - SQL Server 2008 - cached sa password? -
something odd has happened earlier week @ work, , after researching , googling answer, still none wiser!
so hoping shed light on might have occurred.
i after company's database , on monday - logged check on things , ok.
the next day, job failed run, on step updates database using 'sa' account - had login failure.
so after checking sql server logs, can see 20 minutes after had logged off, 'sa' had began fail every 6 minutes.
so after speaking company said changed 'sa' accounts password last friday, , had half expected job fail on weekend, had taken until following tuesday fail.
this doesn't make sense me - sounds sa credentials had been cached, , when opened , closed management studio on monday, had purged cached credentials?
does perhaps know why behaviour has occurred, explanation absolutely awesome. seems strange me right now!
the credentials, or connections. changing sa password not invalidate open connections. , if have lot of load server db connection pooling enabled, connections can stay open long time.
Comments
Post a Comment