Recently I got a problem where Builtin\Administrators Account was deleted . How can we recreate it?
Here is a solution for this
Run this proc
EXEC sp_grantlogin 'BUILTIN\Administrators' to recreate it
Then give it sysadmin rights on the server.
Or in Management Studio
go to
Secuirty -> Logins -> right click to new login
Type 'BUILTIN\Administrators' as login name , choose widows Authentication
In Server Roles , give its a right of sysadming
By default this account all adminstrator in the administrators account.

Here is a solution for this
Run this proc
EXEC sp_grantlogin 'BUILTIN\Administrators' to recreate it
Then give it sysadmin rights on the server.
Or in Management Studio
go to
Secuirty -> Logins -> right click to new login
Type 'BUILTIN\Administrators' as login name , choose widows Authentication
In Server Roles , give its a right of sysadming
By default this account all adminstrator in the administrators account.
No comments:
Post a Comment