SQL account

Results 1 to 2 of 2
  1. #1
    Novice kosmeckcs is offline
    MemberRank
    Nov 2012 Join Date
    3Posts

    smile SQL account

    How can I retrieve my sqlserver acc ? -_- *NOOB T_T*
    PLEASE HELP ME HOW CAN I RETRIEVE IT ?
    ( IF POSSIBLE, THE EASY WAY PLEASE )


  2. #2
    Lage Company™ afonsolage is offline
    MemberRank
    Mar 2012 Join Date
    Fortaleza, BRALocation
    244Posts

    Re: [HELP]SQL account

    You mean reset SA password?

    Set database to Single User mode:

    1 - In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

    2 - Right-click the database to change, and then click Properties.

    3 - In the Database Properties dialog box, click the Options page.

    4 - From the Restrict Access option, select Single.

    5 - If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes.

    In single user mode, every windows local user is administrator, so go to security session and reset sa password. After it, reset database to Multi User mode.


    Best regards,

    Afonso Lage.



Advertisement