June 21, 2018 at 8:24 am
For all those who are facing this issue with SQL 2016/2017, following can help. It helped me.
Please note, this setting needs to be disabled in addition to EXEC sp_configure 'remote proc trans', '0';
RECONFIGURE;
August 14, 2023 at 9:39 pm
I have to post this.
I literally just read my own post and it resolved the same problem.
I'm updating the error message just because it might help me again, or someone else!
TITLE: New Publication Wizard
------------------------------
SQL Server could not create publication 'Testing'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.
Changed database context to 'TestingDB'. (Microsoft SQL Server, Error: 3930)
Resolution:
Log in as "sa" and create your Publication and it will not matter what account you use, whether it is Domain or a Local Windows Security Account.
Let this be a lesson. Write stuff down. The person you help might be yourself!
Regards, Irish
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply