Taking Control of a SQL Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel Ainscoe - 31 Dec 2008 10:15 GMT

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

Reply to this Message

Rick Sawtell - 31 Dec 2008 13:32 GMT

> Hi,
>
[quoted text clipped - 6 lines]
> TIA & HNY
> Nigel Ainscoe

By default the BUILTIN\Administrators role will allow you sysadmin rights
when you log in as a Windows Admin. If this role has been removed from the
sysadmins sql server group, then you are pretty well stuck. Your next
choice is probably to rebuild the master database, set yourself up as an
admin, then reconnect all of the other databases and recreate the other
logins etc.

Rick Sawtell

Reply to this Message

Nigel Ainscoe - 31 Dec 2008 14:09 GMT

Thanks Rick, I think I'll just leave it as it is. It is the Small Business
Server monitoring database and if I start rebuilding the master database I
can see there being no monitoring going on in a very short space of time ;-)

>> Hi,
>>
[quoted text clipped - 15 lines]
>
> Rick Sawtell

Reply to this Message