Talking about Adding BUILTIN\Administrators back to SQL Server

Posted on by

 

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’

One thought on “Talking about Adding BUILTIN\Administrators back to SQL Server”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s