Post reply

SysAdmin account deleted!

  • May 8, 2005 at 3:22 pm

    #102516

    Hello!

    What is solution when SysAdmin account was accidentally deleted from AD and SQL2k dont allow nothing to do with other accounts?

    Recreating account in AD with same name probably will not help because new account will have different SID.

    Any suggestions?

    August S

     

  • May 8, 2005 at 9:46 pm

    #557521

    Do you know the sa password ?

    By default, members of the local administrators group on the server where SQL is installed are sql sysadmins. You could try connecting to SQL using a windows account in this group.

  • May 8, 2005 at 11:26 pm

    #557535

    Try to use one of the fixed server role sysadmin or securityadmin(in order only to create a new login) account.

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

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