I've created a SQL Server 2019 Standard instance in my account.
I am trying to enable XA Transactions (Technical requirement) following this Microsoft documentation:
https://learn.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions?view=sql-server-ver16
I need to use the next sp -> sp_sqljdbc_xa_install but
And it's true, I have no permissions in the master database ->
SQL Error [262] [S0001]:
CREATE SYNONYM permission denied in database 'master'.
Is it possible to enable XA transactions in SQL Server 2019 Standard managed instance with GCP?
I've been able to enable it in a hosted SQL server with superuser permission without any problem.