Error messages and problem solving

A warning or error message might be displayed in the user interface to provide information about the adapter or when an error occurs.

The following table contains warnings or errors which might be displayed in the user interface if the SQL Server Adapter is installed on your system.

Table 1. Warning and error messages
Warning or error message Possible cause Corrective action
Unable to establish connection with the SQL Server. This error occurs when the managed resource is not up or when the value of following attributes are specified incorrectly on the service form:
  • Administrator name
  • Password
 Ensure that the managed resource is up and the value of following attributes are specified correctly on the service form:
  • Administrator name
  • Password
LoginId already exists. This error occurs when a request is made to add a user account that already exists. Create a user account with another user ID.
LoginId does not exist on SQL server. A request was made to either modify, suspend, restore, or delete a user account that does not exist on the managed resource. Ensure that the user exists on the managed resource and is not directly deleted or modified on the managed resource.
Unsupported SQL Server Version. This error when an attempt is made to manage the SQL Server that is not supported by the adapter. Ensure that the SQL Server Adapter supports the SQL Server that you are using.
Fail to delete this account since "sa" is a system account. This error occurs when an attempt is made to delete a system account sa. The adapter returns the sa account in a reconciliation operation, however, you cannot delete this account. Do not manage this accounts from IBM® Security Privileged Identity Manager.
Unable to add new loginId :: Microsoft OLE DB Provider for SQL Server :: Error #: 80040e14?The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF. This error occurs when only the User must change password at next login check box is selected. Select the following check boxes on the Password tab of the account form and perform Select the following check boxes on the Password tab of the account form and perform the operation again:
  • User must change password at next login
  • Enforce password expiration
  • Enforce password policy
Unable to add new loginId :: Microsoft OLE DB Provider for SQL Server :: Error #: 80040e14?The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF. This error occurs when only the Enforce password expiration check box is selected. Select the following check boxes on the Password tab of the account form and perform the operation again:
  • User must change password at next login
  • Enforce password expiration
  • Enforce password policy
Unable to add new loginId :: Microsoft OLE DB Provider for SQL Server :: Error #: 80040e14?Password validation failed. The password does not meet Windows policy requirements because it is too short. This error occurs when:
  • The Enforce password policy check box is selected on the account form.
  • The value specified for the Password attribute on the account form does not meet the password policy requirements.
 Check the:
  • Minimum password length
  • Password complexity
  • Password history requirements