Friday, September 30, 2011

How To Add Back The BUILTIN Administrators Group In SQL Server

While disabling if you had dropped the Built-in Administrator account from the SQL server. Please follow the steps to add back The [BUILTIN\Administrators] group back.

First try in Test box, before doing any changes in Production box. 
USE Master
Go
EXEC SP_Grantlogin 'BUILTIN\Administrators'
GO
EXEC SP_Defaultdb 'BUILTIN\Administrators', 'master'
GO
EXEC SP_Defaultlanguage 'BUILTIN\Administrators', 'us_english'
GO
EXEC SP_Addsrvrolemember 'BUILTIN\Administrators', 'sysadmin'
GO 

The other way as well you can add like below. 
USE Master
GO
CREATE LOGIN [BUILTIN\Administrators] 
FROM WINDOWS
WITH DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english]
GO

Built-in Administrator Account - Enable or Disable. Enable and Disable the Built-in Administrator Account. Security Issues with the SQL Server BUILTIN Administrators Group. Builtin\Administrator. Built in Administrator - Windows-XP-General-Discussion. What is BUILTIN\Administrators. To add Builtin\Administrator account in sql server login. BUILTIN\Administrators removed. How to handle the built-in administrator account in Windows. built in administrator sid. windows 7 built in administrator account. builtin administrator account question. builtin administrator account in sql server 2012. builtin administrator account in sql server 2008 R2. builtin administrator account in sql server 2005. What's special about the builtin Administrator account.

1 comments:

I am not able to find the BUILTIN\Administrators group through GUI?

Post a Comment