Hi learned people. I have low to mid level sql knowledge. I support emr software. I get this issue upon logon; the mentioned error, i will paste at the end. ( i have a client app hitting an sql database). When you keep on trying to log on, upon the eigth or ninth attempt, the logon would work.

Here is my error:

Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

Thank you.