Search Engine: Elastic

Article ID: 116439, created on Jul 15, 2013, last review on May 11, 2014

  • Applies to:
  • Operations Automation


The task 'Delete SQL login for Active Directory user' fails in POA with the error message 'Cannot drop the login 'DOMAIN\user', because it does not exist or you do not have permission'.

Mopre detailed diagnostics is provided below:
Task name: Delete SQL login for Active Directory user 1104 on the host '' (host_id=70)
Destination host '' (#66), IP '' : Provisioning request failed. IDispatch error #3092
[<response><errorContext description="Cannot drop the login 'HOSTING\u86_dbuser', because it does not exist or you do not have permission."
code="0x80040e14" executeSeqNo="2"><errorSource namespace="SQL Provider" procedure="ExecSQL"/></errorContext></response>]


Most likely the SQL login for the Active Directory user was manually deleted or renamed directly on MS SQL server.


Follow the steps below to resolve the problem.

  1. Log into the MS SQL server where database in question is located, IP address and/or hostname of the server may be found in the name of the failed task in POA Task Manager.
  2. Connect to MS SQL server using e.g. Microsoft SQL Server Management Studio.
  3. Open Security > Logins in the left navigation panel.
  4. Check if the SQL login for the user mentioned in the failed task does exist.
  5. If the SQL login does not exist - create it (create corresponding user in Active Directory if needed).
  6. Process the failed task in POA.

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF