Post reply

I Forgot SA Password! Yikes!

  • August 26, 2003 at 7:21 am

    #160625

    Hi there. I did an install of MSDE on my server and for the life of me, cant remember the SA password. Is there any way to change it without knowing it? Or is there any way to find out what it is? I can login as another admin type user just not sa.

    thanks

    Eugene

  • August 26, 2003 at 7:25 am

    #471406

    By Default Administrators group will have sysadmin access on SQL Server. Try accessing thru Windows NT Authentication, you can change "SA" password this way.

    .

  • August 26, 2003 at 7:32 am

    #471408

    How exactly do I change it once I login as an administrator group user? I know a query analyzer script to do it, but it requires the "old" password.

    thanks for the reply!

  • August 26, 2003 at 7:38 am

    #471411

    By default, BUILTIN\Administrators are sysadmins so far as SQL Server or MSDE is concerned. That means if you connect to the MSDE with an account that's an administrator on the system, you're a sysadmin (provided the defaults didn't get changed).

    As a sysadmin, you can run sp_password without having to know the old password. For instance:

    EXEC sp_password @loginame='sa', @new='NewPassword'

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • August 26, 2003 at 7:44 am

    #471412

    THANK YOU THANK YOU THANK YOU!

    I'm all set now! change has been made! thank you so much! What an awesome resource sqlservercentral at our fingertips!

    thanks again

    Eugene

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

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