As a Enterprise Admin, you may or may not be in the local administrators
group on the computer. If so, in SQL Server 2005 the local administrators
group has sysadmin permissions to the SQL Server. Unless someone has removed
it to tighten security. So attempt to connect with your login. If the OS is
Windows Server 2008 or Windows Vista, start SQL Server Management Studio
using the Run as Administrator option so Windows will pass your admin
credentials to SQL Server.
If someone has removed the local administrators from the sysadmin role by
removing BUILTIN\ADMINISTRATORS from the logins, then this will fail. In
that case, restart the Database Engine in single user mode. Then SQL Server
will honor the local administrators group. See the Books Online topic
"Troubleshooting: Connecting to SQL
Server When System Administrators Are Locked Out"
http://msdn.microsoft.com/en-us/library/dd207004.aspx
This is a SQL Server 2008 topic but someone recently told me it works on SQL
Server 2005 also.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nigel Ainscoe" wrote in message
> Hi,
>
> I have a SQL Server 2005 database that I do not have sysadmin credentials
> for, only Public, but I need to take control of it. I.e. give myself
> sysadmin. I have Enterprise Admin credentials on the domain.
>
> Anyone know what the best/quickest way of going about this?
>
> TIA & HNY
> Nigel Ainscoe
>
> I have also posted this in sqlserver.programming as I was not sure which
> would be the better group for such a question. Apologies for cross
> posting.
>
FAQ
Search
Profile
Private Messages
Log in
