Post reply

Changing the SA Password in the MSDE

  • December 1, 2003 at 4:57 am

    #66167

    Hello All

    Is there a way to change the SA Password in the MSDE version 8.00.382, I know in Full SQL you can, but what about the Desktop version MSDE?

    Thanks in advance

    Steve

    sriley@capitaes.co.uk

  • December 1, 2003 at 5:47 am

    #484097

    you can use sp_password:

    EXEC sp_password 'OldPass', 'NewPass', 'sa'

  • December 1, 2003 at 6:00 am

    #484100

    Thanks, that works a treat, what happens if the user has forgotten the current password, i was told they have to uninstall MSDE and reinstall it, is this correct.

    Thanks

    Steve

  • December 1, 2003 at 8:15 am

    #484122

    Can you attach to the MSDE instance from a machine with client tools on it and then use EM or the sp_password command? Another alternative is to install client tools on the machine (even temporarily) in order to change the password. There are also free tools like SQL Buddy which is like QA but releases as open source (see http://sqlbuddy.sourceforge.net/about.shtml) Uninstalling MSDE and reinstalling may be a pain unless you take care about detaching, and saving and required databases.

    Francis

  • December 1, 2003 at 11:20 am

    #484142

    Thanks a lot, i will have a look

    Steve

  • December 2, 2003 at 4:00 pm

    #484383

    The Microsoft web site for MSDE lists several 3rd party admin tools for MSDE 2000. Teratrax has a free eval download.

    http://www.microsoft.com/sql/msde/partners/default.asp

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply