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 		Previous revision
Next revision Both sides next revision
tutorial:adm:mssql_database_support [2019/05/06 11:53]
kopro [Develop CzechIdM with MsSQL and a docker] 		tutorial:adm:mssql_database_support [2020/06/10 16:53]
apeterova domain user, permissions
Line 46: Line 46:
 GO GO
 -- grant permission for the schema (grant all is deprecated) -- grant permission for the schema (grant all is deprecated)
 +-- sometimes this is not needed when the user is owner of the schema - then you get 'Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.' which is OK
 GRANT ALTER, CONTROL, CREATE SEQUENCE, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, TAKE OWNERSHIP, UPDATE, VIEW CHANGE TRACKING, VIEW DEFINITION ON SCHEMA::bcv_idm_storage TO idmadmin; GRANT ALTER, CONTROL, CREATE SEQUENCE, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, TAKE OWNERSHIP, UPDATE, VIEW CHANGE TRACKING, VIEW DEFINITION ON SCHEMA::bcv_idm_storage TO idmadmin;
 GO GO
Line 55: Line 56:
 GO GO
 </code> </code>
 +
 +<note tip>
 +If you use a domain user to connect to the database, use this syntax: ''CREATE SCHEMA bcv\_idm\_storage AUTHORIZATION "DOMAIN\idmadmin;"''.
 +
 +If your domain user has a very long username (e.g. "sql\_dbinstance'_czechidm", then you must supply only the shorter sAMAccountName, typically first 20 characters - e.g."sql\_dbinstance\_czech").
 +</note>
  
 ==== Download a JDBC driver ==== ==== Download a JDBC driver ====
Line 89: Line 96:
 ===== Supported version of MsSQL ===== ===== Supported version of MsSQL =====
   * **14.0** - 2017 SQL Server 2017   * **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.''
  
  
  • by doischert