Post reply

Revlogin script for sa account.

  • November 30, 2017 at 4:03 am

    #409813

    Hi,

    Is  there  any way where we can script out revlogin for sa account. The problem is we dont know the password for the current sa account.
    As per the audit requirement we need to change the password for the sa account.
    In-case if there are any application dependent on the sa account. it will have issue post the password reset.
    Is there any way we can reset the old password with the revlogin script for sa account.

    i did get the revlogin for sa
    CREATE LOGIN [sa] WITH PASSWORD = 0x0200901AFB54F606E007F91AC7310EBC3DBC5C744707BC47E112391B991EE972ddddd6E5FAE980777F4E66541B9F313C612831825A031504ADB59C9FDC63E84E9228808FCF811871A HASHED, SID = 0x01, DEFAULT_DATABASE = [master], CHECK_POLICY = ON, CHECK_EXPIRATION = OFF

    but when i run this i get a error "Msg 15419, Level 16, State 1, Line 1
    Supplied parameter sid should be binary(16)."

    Regards
    Prasanna Shetty

  • November 30, 2017 at 4:15 am

    #1970008

    Prasanna

    I'm not sure why you're getting that error message.  But you need to use ALTER LOGIN instead of CREATE LOGIN, since the sa login already exists. - then you don't need to specify the SID.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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