FIX: "Incorrect syntax" error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


Assume that you publish a Transparent Data Encryption (TDE)-encrypted database for transactional replication in Microsoft SQL Server 2016. When you use the sp_addpullsubscription_agent stored procedure to add a subscription to the publication, you may receive an error message that resembles the following:

Msg 102, Level 15, State 1, Procedure sp_MSaddreplsymmetrickey, Line 42
Incorrect syntax near 'TRIPLE_DES'.

Resolution


This fix is included in the following updates:

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.