Ask the Community
Groups
Kaseya Server Installation Fails for SQL 2017 - Connect IT Community | Kaseya
<main> <article class="userContent"> <h3 data-id="problem">Problem</h3> <p>The Kaseya Server installation/upgrade fails with the following error:</p> <p><em>System Error [0] Message: CREATE or ALTER ASSEMBLY for assembly 'KID' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly. </em></p> <h3 data-id="cause">Cause</h3> <p>SQL 2017 introduces a new DB schema security that defaults to "On" and must be turned "Off" in order to proceed. The new '<em>clr strict security</em>' is an advanced option that is hidden by default and cannot be reconfigured without showing the advanced options.</p> <h3 data-id="workaround">Workaround</h3> <ul><li>Execute the following queries in this order:</li> </ul><pre class="code codeBlock" spellcheck="false" tabindex="0">EXEC sp_configure 'show advanced options' , 1; <br>RECONFIGURE;</pre> <ul><li>Next, execute this one:</li> </ul><pre class="code codeBlock" spellcheck="false" tabindex="0">EXEC sp_configure 'clr strict security' , 0; <br>RECONFIGURE;</pre> <ul><li> Once the SQL queries run, go ahead and re-run the <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fdownload.kaseya.com%2FKInstall.exe" rel="noopener nofollow">KInstall</a> once again - this time it should complete without any errors.<br></li> </ul><p><strong>Note:</strong> If you incur any issues or the above does not correct the problem, please create a Support Case via <a href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/hc/en-gb/requests/new" rel="noopener nofollow">this link</a>.</p> </article> </main>