Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
tutorial:adm:mssql_database_support [2019/01/29 08:16]
kotisovam 		tutorial:adm:mssql_database_support [2019/04/01 06:34]
kopro [MsSQL: Run CzechIdM with MsSQL database] information about snapshot in databaase
Line 5: Line 5:
 <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>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 =====  =====  Setup MsSQL with CzechIdM ===== 
  
  • by doischert