title: MS SQL Server 2017 - Error following official tutorial - creating new publication while setting up transactional replication
body: <p>I am trying to set up replication using SQL Server 2017 Developer edition. The publisher, distributor, and subscriber are all local. I have been (faithfully) following the tutorial here: </p>
  
  <p><a href="https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-2017" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-2017</a></p>
  
  <p>In the section "Configure the publisher for transactional replication" after completing step 13 and clicking "Finish", which should create the initial snapshot for replication, the New Publication Wizard reports there was an Error Creating Publication 'AdvWorksProductTrans'. The message is clickable and launches a dialog that reads as follows:</p>
  
  <blockquote>
    <p>SQL Server could not create publication 'AdvWorksProductTrans'.</p>
    
    <p>Additional information:</p>
    
    <p>-> An exception occurred while executing a Transact-SQL statement or batch.</p>
  
  <pre><code>(Microsoft.SqlServer.ConnectionInfo)
  
  -&gt; 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 'AdventureWorks2012'. (Microsoft SQL Server, Error: 50000)
  </code></pre>
  </blockquote>
  
  <p>Any help will be greatly appreciated. Thanks!</p>