Post reply

Problems resetting sql password - database deleted

  • June 19, 2012 at 2:41 am

    #392550

    I have a sql login which is used by an application on several databases. Some time ago one of the database was removed because the customer left us. This is on our test environment.

    When I try to reset the password in Security->Logins on the server it complains about the missing database. I can reset the password at the database level OK using sp_password. I suspected it was an orphaned user but running "EXEC sp_change_users_login 'Report'" doesn't show anything.

    Screenshot attached.

    Any ideas

    keith

  • June 19, 2012 at 3:20 am

    #1502643

    Is the deleted database default for the user. check the user properties.

    Regards
    Durai Nagarajan

  • June 19, 2012 at 4:26 am

    #1502695

    Thanks.

    That was it. There was nothing listed in default for user, missed that one. Set a new default and it works now

    🙂

    keith

  • June 19, 2012 at 4:32 am

    #1502699

    happy to help..

    Regards
    Durai Nagarajan

  • June 20, 2012 at 10:24 pm

    #1503755

    Reset sql password by Windows Authentication

    If Built-in/Administrator is present in SQL , you can login with an ID which is member of Administrators group and reset password in SQL . Just do as follows:

    Step 1. Login into SQL server using Windows Authentication.

    Step 2. In Object Explorer, open Security folder, open Logins folder. Right click on sa account and go to Properties.

    Step 3. Type a new SQL password, and confirm it. Click OK to finish.

    Reset SQL 2005 password
    retrive SQL login password

  • June 21, 2012 at 1:18 am

    #1503791

    hrr1117 (6/20/2012)

    Reset sql password by Windows Authentication

    If Built-in/Administrator is present in SQL , you can login with an ID which is member of Administrators group and reset password in SQL . Just do as follows:

    Step 1. Login into SQL server using Windows Authentication.

    Step 2. In Object Explorer, open Security folder, open Logins folder. Right click on sa account and go to Properties.

    Step 3. Type a new SQL password, and confirm it. Click OK to finish.

    hrr1117 kindly note user got error while resetting the password, not asking help for resetting the password.

    Regards
    Durai Nagarajan

  • July 3, 2012 at 9:11 am

    #1508286

    Different issue in SQL Server can cause inaccessibility in SQL Server Password which needs some special observation or action.

    User can RESET SQL Password with the help of some external programmed device like SQL password recovery tool.

    Visit at: http://www.unlocksqlserverpassword.n.nu/[/url]

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

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