Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    2

    Unanswered: LOST SA USER on MSDE

    Hi!

    I have a problem: i locked me out of our MSDE

    I wanted to change the SA password like this:
    PHP Code:
    osql -U sa -"sp_password NULL, 'secretPW'" 
    then later i had to open it again (for a stupid application):

    PHP Code:
    osql -U sa -"sp_password 'secretPW', ''" 
    it's an empty password.
    But now i can't connect anymore. Even with old passwords...

    Do you have any ideas?

    thx a lot

    lacroix

  2. #2
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    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

  3. #3
    Join Date
    May 2002
    Posts
    2

    Thumbs up

    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!!

    so long

    L.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •