Article ID: 129738, created on Oct 29, 2016, last review on Oct 29, 2016

  • Applies to:
  • Operations Automation

Symptoms

Task for dropping of database user fails with the error:

Cannot change owner of object 'u123456_username.aspnet_Setup_RestorePermissions' or one of its child objects because the new owner 'dbo' already has an object with the same name."

Cause

Error occurred because indeed dbo sys user already has mentioned sys objects.

Resolution

Existence of such sys objects can be checked on DB host that is mentioned in failed task. Query should be like:

select * from  dbo.sysobjects where name='aspnet_Setup_RestorePermissions';

Confirm that there are such records, delete them, after that the task can be processed.

Search Words

Destination host 'EXMPS01.win-sv.com' (#238), IP '10.1.12.188' : Provisioning request failed. Unknown error 0x80131904 [<response><errorContext description="The login 'u1018600_bunka' already exists." code="0x80131904" executeSeqNo="1"><errorSource namespace="SQL Admin Provider" procedure="AddLogin"/></errorContext></response>]

Cannot change owner

The login 'u1018600_bunka' already exists.

Drop database

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF