Post reply

Sql server ''sa'' password

  • August 16, 2007 at 10:56 am

    #180315

    Hello All,

    I have gor Sql server installed on my machine and currently I have forgotten password of 'sa' account.

    I am able to access database and can query using my windows authentication but I need 'sa' password for one of my application. I cannot get sql server installed again as it will take time at my organisation level due to processes in place.

    Please can anyone let me know how to retrieve my 'sa' password as it is required urgently.

    Regards,

    Vivek

     

     

     

    /**A strong positive mental attitude will create more miracles than any wonder drug**/

  • August 16, 2007 at 11:05 am

    #727438

    Not sure how to get it, but can you change the password using sp_password?

  • August 16, 2007 at 11:08 am

    #727442

    Hi Mike,

    I can't change the 'sa' password using sp_password as I have forgotten the previous old password.

    Regards,

    Vivek

     

     

    /**A strong positive mental attitude will create more miracles than any wonder drug**/

  • August 16, 2007 at 11:26 am

    #727445

    if you are in as a builtin\Administrator, you can still use the sp_password, you simply leave oldpassword as null.

    an admin does not need to know the old password,  so you'd be all set.

    BOL has that exact example i believe.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 16, 2007 at 11:29 am

    #727446

    If you change it in Enterprise Manager I don't think it requires you to know the old password.

    Regards,
    Rubes

  • August 16, 2007 at 10:13 pm

    #727535

    Login as An Administrator and go the Enterprise Manager, connect to the server where you would be chaging "sa" password, Go to Security > Logins> double click on "sa" login and enter the new password. This way you woudl have ownership of "sa" login.

    Remember if your applications or packages or jobs are using "sa" password you would have to replace this with new password/



    brijesh

  • August 17, 2007 at 2:09 am

    #727560

    I saw this recently.  Scared me and haven't tested it but ...

     

    http://www.simple-talk.com/sql/t-sql-programming/temporarily-changing-an-unknown-password-of-the-sa-account-/

  • August 17, 2007 at 2:12 am

    #727563

    You can do this if you are a member of the local administrators of the machine where sql server is running.

     

    N 56°04'39.16"
    E 12°55'05.25"

  • August 17, 2007 at 8:02 am

    #727651

    This is the classic reason for not letting apps use sa.

    So who wrote the application that uses the sa password?  If it is in house, you need to change the application to not use sa.  If it is a purchased app, get after that vendor.  It may not solve the immediate problem but it will avoid them in the future.

    Steve

  • August 17, 2007 at 9:19 am

    #727677

    http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php

  • December 24, 2011 at 9:14 pm

    #1425392

    WILLIAM MITCHELL (8/17/2007)

    <A href="http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php">http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php</A>%5B/quote%5D

    Could you please explain?

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • December 26, 2011 at 9:38 am

    #1425510

    Use enterprise manager to change the password . Any member of the administrators group should be able to connect to the server using windows authentication . This was the default in 7 and 2000 . You will not be asked for the old password , just use the GUI .

Viewing 12 posts - 1 through 11 (of 11 total)

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