August Savi
SSC Enthusiast
Points: 174
More actions
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
happycat59
One Orange Chip
Points: 29384
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.
Vidas Zabinskas
Hall of Fame
Points: 3258
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