user mapped as dbo

Question

Post reply

user mapped as dbo

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

inund8ed Ten Centuries Points: 1337 More actions · Answer 1

This is not the database owner, another account is (but not sa).

I will try to change ownership to sa.

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 2

sage8 (8/20/2012)
This is not the database owner, another account is (but not sa).

That does not add up.

I will try to change ownership to sa.

How did it go?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

inund8ed Ten Centuries Points: 1337 More actions · Answer 3

Changing the database ownership to 'sa' fixed it, the dbo account at the database level automatically mapped to sa.

The user account we wanted to remove were no longer mapped to that db and we were able to drop that login.

Thanks to everyone for their help and input!

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 4

Excellent. Thanks for posting back that you were able to resolve the issue.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Arun S Prasad Valued Member Points: 55 More actions · Answer 5

Hi All,

When I changed the db owner to SA , I could delete the login.

The below code was helpful.. Thank you

USE [your_database];

GO

SELECT SUSER_NAME(principal_id)

FROM sys.database_principals

WHERE name = 'dbo';

GO

paul.carpenter Valued Member Points: 57 More actions · Answer 6

Brilliant. been searching forums for this solution and this ALTER AUTHORISATION ON Database did the job.

Thanks very much!!

Perry Whittle SSC Guru Points: 233860 More actions · Answer 7

sierra4 (8/20/2012)
DBINFO @0x000000004329E480
dbi_dbid = 10 dbi_status = 65544 dbi_nextid = 1933301997
dbi_dbname = TRACKIT80_2007 dbi_maxDbTimestamp = 1129100 dbi_version = 655
dbi_createVersion = 539 dbi_ESVersion = 0
dbi_nextseqnum = 1900-01-01 00:00:00.000 dbi_crdate = 2011-05-11 08:58:49.677
dbi_filegeneration = 0
dbi_checkptLSN
I presume this was a SQL 6.5 db originally?

Nope, create version 539 is SQL server 2000 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉