Hello @Everyone,
I managed to fix the issue where the robot cannot connect to sql database using windows authentication.
FIX: used connect to database activity instead of StartTransactions and changed the connection string IntegratedSecurty=True to SSPI