1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “Unable to connect to the database: Cannot open database “16” requested by the login. The login failed. Login failed for the user ‘sa'” – BACKTRACK Error Message

“Unable to connect to the database: Cannot open database “16” requested by the login. The login failed. Login failed for the user ‘sa'” – BACKTRACK Error Message

Summary


This Error Message Article explains the BACKTRACK error message “Unable to connect to the database: Cannot open database “16” requested by the login. The login failed. Login failed for the user ‘sa’.” and details how to fix the underlying problem that caused it to appear.

Explanation

This error was triggered by an incorrectly configured item in the ITEM table. In this case, BACKTRACK is being used for item tracking. No parent item involvement. However, some of the items were entered with PARENT_ITM flag set to 1 and the corresponding records in RELATION also has value in P_ITEM_NO instead of blanks.

Solution

Note: This solution requires direct access to the SQL database.  If you do not have full understanding of the databases, please contact us for assistant.  Exercise extreme caution before attempt this solution.

Set the PARENT_ITM to 0 in ITEM table and set the P_ITEM_NO to blank in the RELATION table.

Additional Comments

None

Updated on July 28, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support