Ask the Community
Groups
9.4 Schema installation fails on non-English locals (OS/SQL language) - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Problem:</strong></p> <p>If you install Kaseya 9.4 anew or upgrade to this latest version, the database configuration ('reapply schema) might fail reporting 'invalid date format' in the respective language the OS is installed in. Below examples from a French and a German installation:</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/NJJONMIIVJTI/172988.png" alt="172988.png" class="embedImage-img importedEmbed-img"></img></p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/1T4YVPJIAQYH/kservererror-png.png" alt="KServerError.PNG" class="embedImage-img importedEmbed-img"></img></p> <p>This is due to the date format SQL server expects, based on the different language selected.</p> <p> </p> <p><strong>Solution:</strong></p> <p>Kaseya uses SQL users to connect to the database. You can find out which users these are by checking the content of the *:\Kaseya\Kserver\kserver.ini against the list of logins in SQL Management Studio.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/KD95OR5AAZ2W/2017-03-02-12-16-57-9-4-schema-installation-fails-on-non-english-locals-os-sql-language.png" alt="2017-03-02_12_16_57-9.4_Schema_installation_fails_on_non-English_locals__OS_SQL_language_.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p>Edit these relevant logins and set their language as shown below, to English:</p> <p> </p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/MQT5B9L5PCBE/2017-03-02-08-15-59-9ff5963a4296718560d7e6b8c20ac0129ec1d815a23dd4bd74-pimgpsh-fullsize-distr-png.png" alt="2017-03-02_08_15_59-_9FF5963A4296718560D7E6B8C20AC0129EC1D815A23DD4BD74_pimgpsh_fullsize_distr.png__.png" class="embedImage-img importedEmbed-img"></img></p> <p> Once the change has been applied, please re-run the 'Reinstall Database Schema' process, either from the Start Menu on the Kaseya application server</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/D0SJH8G3RRKP/2017-03-02-12-24-00-9-4-schema-installation-fails-on-non-english-locals-os-sql-language.png" alt="2017-03-02_12_24_00-9.4_Schema_installation_fails_on_non-English_locals__OS_SQL_language_.png" class="embedImage-img importedEmbed-img"></img></p> <p>or by simply calling this URL in a browser on the server's desktop:</p> <p> </p> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2F127.0.0.1%2FlocalAuth%2FinstallSchema.asp%3FlocalApply%3Dtrue">http://127.0.0.1/localAuth/installSchema.asp?localApply=true</a></p> </article> </main>