How to resolve error initialization failed on the log file, while installing erwin Web Portal on (4294835)

Warning: Please use this suggested guideline at your own discretion. We suggest that you liaise with your own IT/DBA professional to assist you with this.

Error/issue:

Database initialization failed. [Thread-8] 2018-11-27 16:14:38 MIRWEB_I0092 Deleting the database structures.
[Thread-8] 2018-11-27 16:14:38 DBUTL_I0002 ********** Executing script: /SQLServer/DeleteDDL.sql *******

Symptoms:

When I install erwin Web portal on sqlserver 2017, you may get error Initialization failed error message on the log. The reason is that Microsoft added new security features that restrict the usage of database code, see: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-assembly-transact-sql?view=sql-server-2017

Resolution:

For sqlserver 2017 and higher version, you will need to disable the CLR strict security by running the following commands: 

EXEC sp_configure 'show advanced options', 1
RECONFIGURE;
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;
EXEC sp_configure 'show advanced options', 0
RECONFIGURE;

For more information, please see readme:

http://www.metaintegration.com/erwin/ReadMe/MIMMReadme.html#DatabaseOnMicrosoftSQLServer