Cloud & SQLSailor

Quote

Adding BUILTIN\Administrators back to SQL Server

Recently I had to add BUILTIN\Administrators back to the server and here is what I had to do for the same.

 

Run following TSQL queries

EXEC sp_grantlogin ‘BUILTIN\Administrators’
and
EXEC sp_addsrvrolemember ‘BUILTIN\Administrators’,’sysadmin’