reset MSSQL password

Discussion in 'MySQL' started by paul.martin, Jun 12, 2006.

0
  1. #1
    How do I reset the MSSQL password for the sa (root) account?

    Thank you.
     
    paul.martin, Jun 12, 2006 IP
  2. itdevil

    itdevil Well-Known Member

    Messages:
    632
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    110
    #2
    itdevil, Jun 17, 2006 IP
  3. tech86

    tech86 Peon

    Messages:
    83
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    try oxid.it Cain n abel if u have local / phyiscally access
     
    tech86, Jun 17, 2006 IP
  4. paul.martin

    paul.martin Peon

    Messages:
    260
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #4
    hi Guys. Thax for the answers but I was talking about MSSQL, not mySQL.
    And yes, I have the Administrator account on the machine and I just want to reset the MSSQL sa password without reinstalling.

    Thanx
     
    paul.martin, Jun 18, 2006 IP
  5. ohidur

    ohidur Member

    Messages:
    67
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #5
    pls try with the following Codes

    Syntex:
    sp_password [ [ @old = ] 'old_password' , ]
    { [ @new =] 'new_password' }
    [ , [ @loginame = ] 'login' ]

    Example:
    EXEC sp_password NULL, 'ok', 'Victoria'
     
    ohidur, Jun 19, 2006 IP