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

0 users found this article helpful

Symptoms

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

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

 

Cause

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

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

Was this article helpful?

Tell us how we can improve it.