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
