Node Builder – Incorrect syntax near ‘TRIPLE_DES’

Published: May 10, 2017
Post Author Written by eOne Solutions

I am trying to install Node Builder and receiving the error “incorrect syntax near ‘TRIPLE_DES'”. The Node Builder database is created but it contains no tables.

This is due to an encryption type that is deprecated in SQL Server 2016.

Open SQL Server Management Studio and locate the Node Builder Database.
Right-Click and choose Properties.
From the Database Properties window, select the Options from the Page list on the left hand side.

Change the Compatibility level to SQL Server 2012 (110).

Run the Node Builder install again and it will successfully complete the process.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.