April 9, 2011 at 10:00 am
Hi All,
I have read some where in this forum that if we start SQL Server in single user mode, Administrators of that box can access if built-in\administrators removed also. is that right ?
I tried to search for that topic, but didn't found it.
Thank You.
Regards,
Raghavender Chavva
April 9, 2011 at 11:28 am
Yes you are right. This article has more information about it.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
April 9, 2011 at 11:40 am
Also, see this MSDN article. At the bottom, it states
Also, if SQL Server 2005 is started in single-user mode, any user who has membership in the BUILTIN\Administrators group can connect to SQL Server 2005 as a SQL Server administrator. The user can connect regardless of whether the BUILTIN\Administrators group has been granted a server login that is provisioned in the SYSADMIN fixed server role. This behavior is by design. This behavior is intended to be used for data recovery scenarios.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy