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 'MSSQL2008.hosting.local' (host_id=70)
Destination host 'mps.hosting.local' (#66), IP '10.39.94.65' : 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.
- 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.
- Connect to MS SQL server using e.g. Microsoft SQL Server Management Studio.
- Open Security > Logins in the left navigation panel.
- Check if the SQL login for the user mentioned in the failed task does exist.
- If the SQL login does not exist - create it (create corresponding user in Active Directory if needed).
- Process the failed task in POA.