topic RE: SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016 in Product Forum

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

Stefan__Pappalardo — Wed, 01 Sep 2021 15:39:00 GMT

#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
------------------------------

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

EmersonF — Wed, 01 Sep 2021 17:33:00 GMT

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!
------------------------------

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

Stefan__Pappalardo — Thu, 02 Sep 2021 07:07:00 GMT

Sorry for beeing too late. 😉 And I'm happy that you like the tech tip. 🙂

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