[25000] [FreeTDS][SQL Server]The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (3903) (SQLEndTran)

Symptoms

During the installation and when specifying a Microsoft SQL Server, the following error appears during validation:

Cause

The specified SQL user does not have the correct permissions on the SQL database:

• db_datareader
• db_datawriter
• db_owner

Resolution

On the Microsoft SQL Server, assign the roles listed above.

When using Microsoft SQL Server Management Studio and after connecting to the database:

1. Go to Databases > (select the relevant database) > Security > Users.
2. Right-click the user and choose Properties.
3. On the left, under Select a page, click Membership.
4. In the overview, check these Role Members:
   • db_datareader
   • db_datawriter
   • db_owner