Follow

9.4 Schema installation fails on non-English locals (OS/SQL language)

Problem:

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:

172988.png

KServerError.PNG

This is due to the date format SQL server expects, based on the different language selected.

 

Solution:

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.

2017-03-02_12_16_57-9.4_Schema_installation_fails_on_non-English_locals__OS_SQL_language_.png

 

Edit these relevant logins and set their language as shown below, to English:

 

2017-03-02_08_15_59-_9FF5963A4296718560D7E6B8C20AC0129EC1D815A23DD4BD74_pimgpsh_fullsize_distr.png__.png

 Once the change has been applied, please re-run the 'Reinstall Database Schema' process, either from the Start Menu on the Kaseya application server

2017-03-02_12_24_00-9.4_Schema_installation_fails_on_non-English_locals__OS_SQL_language_.png

or by simply calling this URL in a browser on the server's desktop:

 

http://127.0.0.1/localAuth/installSchema.asp?localApply=true

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.