During the install of Remote Administrator 6.0 setup fails during the database creation. The msi installer log reports the following after enabling verbose logging:
MSI (s) (7C!A0) [16:30:10:422]: Creating MSIHANDLE (840) of type 790531 for thread 17312 ERROR: (DbCreate) Statement execution failed. Error: Conversion of varchar-datatype to datetime-datatype resulted in an out-of-range value. File: C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\4_init_data.sql. Statement: INSERT INTO tbl_security_users (user_id, user_uuid, user_login, user_comment, password_change_timestamp, change_password_on_next_logon, password_expiration_interval_in_days, auto_logout_time_in_minutes, user_full_name, user_email, user_phone, user_state, disabled, native, removed, user_password_hash, user_password_salt) VALUES (5, dbo.ufn_uuid_str_to_binary('00000000-0000-0000-7002-000000000001'), 'system', '', '2012-01-26 12:00:00', 0, 1500, 10, 'System user', '', '', 0x, 0, 1, 0, 0x20, 0x20), (6, dbo.ufn_uuid_str_to_binary('00000000-0000-0000-7002-000000000002'), 'Administrator', '', '2011-10-12 12:00:00', 0, 1500, 10, 'Administrator', '', '', 0x, 0, 1, 0, );
MSI (s) (7C!A0) [16:30:10:422]: Closing MSIHANDLE (840) of type 790531 for thread 17312
Our SQL server is set to Dutch language settings. It appears that the script tries to insert a date in the US format while the server expects Dutch format.
Any idea on how to solve this?
Franc.
