var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Login failed for user sa, error 18456
We have an application which uses SQL Server 2K through MDAC 2.5 on Windows 2K Pro.
After an year of no any problems we started to get 18456 error periodically. What we are doing to fix it is seting "sa" password to let's say "password" one.
It works for some days, but then error appears again, and recovery way is all the same - to set "sa" password to "password".
Any suggeston what can corrupt "sa"'s password?
How to be protected from it? (any patches?)
check your registry maybe the login mode changes
must be set at 2
to use tha sa login