Differences

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

--- tutorial:adm:mssql_database_support [2019/04/01 06:34]
kopro [MsSQL: Run CzechIdM with MsSQL database] information about snapshot in databaase
+++ tutorial:adm:mssql_database_support [2020/06/03 14:00]
apeterova [Supported version of MsSQL]
@@ 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 88: / Line 89: @@
 ===== Supported version of MsSQL =====
   * **14.0** - 2017 SQL Server 2017
+    * Tested version: 14.0.3294.2
+    * Unsupported version: 14.0.1000.169 - contains a bug, which causes failure of the task DeleteExecutedEventTaskExecutor with the following error: ''SQL Error: 21, SQLState: S0001. Warning: Fatal error 605 occurred'', event viewer: ''Attempt to fetch logical page (1:604718) in database 5 failed. It belongs to allocation unit 72057594065387520 not to 72057594089439232.''
@@ Line 101: / Line 104: @@
 ===== Develop CzechIdM with MsSQL and a docker =====
+Beware this is recommended only for develop.
-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
-Copy the initial script (init script is described above, in our example the name of the script file is import.sql)
+Copy the initial script (init script is described above. Just copy and create file with defined sql queries, in our example the name of the script file is import.sql)
    $ docker cp import.sql test-mssql:/import.sql