Talking about Adding BUILTIN\Administrators back to SQL Server


 

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’
Advertisements

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:

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s