Article ID: 121036, created on Apr 11, 2014, last review on Apr 30, 2014

  • Applies to:
  • Operations Automation 5.4

Symptoms

Task Drop database user for MS SQL user fails with error:

Login is aliased or mapped to a user in one or more database 

Cause

This error is returned by the MS SQL server itself, and can be reproduced by running query

exec sp_droplogin '<USER_LOGIN>';

It may be caused by a bug in MS SQL: http://support.microsoft.com/kb/223999

Resolution

Please refer to Mictosoft article http://support.microsoft.com/kb/223999 for resolution, or try to use Enterprise Manager utility to delete this user. After that, rerun the task.

Search Words

failed task

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF