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

  • Applies to:
  • Operations Automation

Symptoms


The task 'Drop database user' fails in POA with the error message "USER is not a valid login or you do not have permission".

More detailed diagnostics is provided in the example below:
Task name  Drop database user u86_test on host 10.39.84.67
Last execution output:
Destination host 'mps.hosting.local' (#66), IP '10.39.94.65' : Provisioning request failed.
IDispatch error #3092 [<response>
<errorContext description="'u86_dbuser' is not a valid login or you do not have permission."
code="0x80040e14" executeSeqNo="3"><errorSource namespace="SQL Provider" procedure="ExecSQL"/>
</errorContext></response>]

Cause


Most likely the SQL login for the user mentioned in the failed task was manually deleted or renamed directly on MS SQL server.

Resolution


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.
  6. Process the failed task in POA.

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF