var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LOST SA USER on MSDE
I have a problem: i locked me out of our MSDE
I wanted to change the SA password like this:
then later i had to open it again (for a stupid application):
osql -U sa -Q "sp_password NULL, 'secretPW'"
it's an empty password.
osql -U sa -Q "sp_password 'secretPW', ''"
But now i can't connect anymore. Even with old passwords...
Do you have any ideas?
thx a lot
Looks like you have entered 'space' as the new password
Try space as the new password or you can Register the same MSDE on some SQL Server EM and try to login using the NT authetication and you might be able to login
Hi sqlserver2k !
Well we tried also the SPACE pw and other key combinations, but nothing worked
We only got it with the secure NT authentication after installing the DbMngr
thx for your help!!