Problem changing DBO login account

[JaybeeinTekTips]

Hi all,

I created a DB (called Iris) and need to give an NT local group ownership of the DB. Now, at the moment my own personal-named login is listed the login for DBO in the Users list, and all my permissions boxes are ticked.

So, I executed a sp_changedbowner 'OurDomain\OurNTLocalGroup', and the system claims the 'OurNTLocalGroup' login does not exist - but it DOES appear twice in EM, in both the Security-logins section and in the IRIS-Users section. (However, I can successfully change the dbo to a couple of other logins)

I then went to IRIS-Users, clicked the Db_owner box for the database role, but nothing - his permissions don't change. I added OurNTLocalGroup to the DD Readers/Writers roles, nothing changed.

Anyone know what I need to do to allocate the group as the DBO?



Thanks,



Jaybee.

 

[ptheriault]

You don't need to change the db owner. Just add the login you want to the dbo role.

sp_addrolemember 'db_owner','<account>'

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

I forgot you can't use sp_addrolemember to add user to the db_owner role. So from SSMS drill down to the security table and open the logins. double click the login you want and select the securables page. From there you can add the login to the db_owner role.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

The reason that you can't make the group the owner, is because a group can't be the owner. A single person has to be the owner, not a group.

The group can be a member of the db_owner role as Paul showed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com