In attempting to create a new Publication for Transactional Replication in SQL Server, I end up getting the following error, with pretty much no way around it:

SQL Server could not create publication 'dfdsf'

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 'farm'. (Microsoft SQL Server, Error: 50000)

For specifics, I did a very basic publication on a single table, with no row filtering. The security accounts used were created based on this tutorial.

This message does not seem very revealing and I cannot find a way around it. Is there any basic trail I can follow to find what I am doing wrong?

  • 2
    What account are you using to create publication ? Seems to me problem with the account that is being used. – Kin Shah May 12 '15 at 21:58
  • 1
    You nailed it - the account i was using didn't have permissions for the database I was creating the publication in. Can you turn your comment into an answer so I can accept it? – dthree May 15 '15 at 4:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.