Differences

This shows you the differences between two versions of the page.

--- tutorial:adm:mssql_database_support [2019/01/29 08:16]
kotisovam
+++ tutorial:adm:mssql_database_support [2019/05/06 11:52]
kopro [Develop CzechIdM with MsSQL and a docker]
@@ Line 1: / Line 1: @@
 ====== MsSQL: Run CzechIdM with MsSQL database ======
+{{tag> sqlserver sql mssql install database supported drivers}}
 The tutorial describes how to run CzechIdM with a Microsoft SQL Server. When following the tutorials [[tutorial:adm:server_preparation|Server preparation]] and [[tutorial:adm:czechidm_installation|CzechIdM installation]] please do skip all the settings and setup related to database.
@@ Line 5: / Line 6: @@
 <note important>The tutorial doesn't describe how to install an MsSQL database. For development you can install MsSQL in a docker, see the section MsSQL in a docker.</note>
+<note important>**Don't forget** to run these queries:
+-----
+ALTER DATABASE bcv\_idm\_storage SET READ\_COMMITTED\_SNAPSHOT ON;
+ALTER DATABASE bcv\_idm\_storage SET ALLOW\_SNAPSHOT\_ISOLATION ON;
+-----
+Otherwise you risk deadlock on database.</note>
 =====  Setup MsSQL with CzechIdM =====
@@ Line 93: / Line 103: @@
 ===== Develop CzechIdM with MsSQL and a docker =====
-Run lasted MsSQL database (change SA-PASSWORD):
+Run lasted MsSQL database (change <SA-PASSWORD> with your password):
    $ docker run --name=test-mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<SA-PASSWORD>' -p 1433:1433 -d microsoft/mssql-server-linux:latest