[Tools] DBeaver could not perform INSERT UPDATE DELETE operations with Microsoft SQL Server instance.

Many of database tools are available for download for free. However, I can't refuse that DBeaver is still the most lightweight and easy to use tool which I select. Everything are working fine til I got this problem according to the topic. This has been a problem to me for a long time. Let's see what happen and how to solve.

The problem:
An SQL Server instance connected by DBeaver could not be "Edit", "Delete", "Insert" via GUI tools in the program. The error message shows that "Internal error: can't obtain entity identifier".

Solution:
Because of the driver working with an instance is not compatible with the Database. To solve this problem is very easy. From the first step of create connection instance, "Microsoft Driver" should be selected in order to work with Ms SQL Database. Avoid using "jTDS driver" with MS SQL.