SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016

[Stefan__Pappalardo]

#BPTechTips​

Issue: In the case you want to install Blue Prism Automate to an existing BluePrism database with disabled Snapshot Isolation the installer tries to enable it. Due to an issue in MS SQL Server 2016 this won't work resulting in an endless installation process never getting completed.

Workaround: Please follow the instractions from SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016

If in doubt ask your database administrator for assistance.

Good luck, and I hope it helps anyone facing the same issue.

------------------------------
Stefan Pappalardo
Technical Product Manager
Commerzbank
Europe/Berlin
------------------------------

[EmersonF]

Nice, I went through a similar situation, if I had known this before, it would have saved me a lot of time

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[Stefan__Pappalardo]

Sorry for beeing too late. ;) And I'm happy that you like the tech tip. :)

------------------------------
Stefan Pappalardo
Technical Product Manager
Commerzbank
Europe/Berlin
------------------------------