Login Failed: Connection has failed with the state of 'Not connected'

[OscarGomez 0]

Hello, decided to upgrade my era 6.5 installation and started with the steps on the page hxxp://support.eset.com/kb6819/. Task ended and got loged out, now i try to log in but i get the error Login Failed: Connection has failed with the state of 'Not connected'.

checking eset services i see that ESET Security Management Center Server service is not starting, checking the logs i can see something failed and is now trying to erase some database tables but failing to do so. this is what appears in the log when I try to start the service:

Quote

2019-07-03 21:51:50 Information: [Thread ad4]: Loading ESET modules from C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Modules\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Local time is 2019-07-03 16:51:55
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProductLine: era
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProductVersion: 7.0.577.0
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: Locale: es_CL
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProductInstanceID: 20a49ffc-0d63-4cac-8df6-1fc6714aa550
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProgramDataDirectory: C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Data\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProductConfigurationDirectory: C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProgramLogsDirectory: C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Logs\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: TempDirectory: C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProgramLibraryDirectory: C:\Program Files\ESET\RemoteAdministrator\Server\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: ProgramEsetUpdatableModulesDirectory: C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Modules\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: InstallConfiguration: CrashDumpsDirectory: C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Dumps\
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Hardware Fingerprint: 0100D718-7EAD-53F1-C9F8-8DEA555F5237
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded ESET modules: 1=1070,18=1708,40=1663.13,10=1267,46=1027,25=1045
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Used memory before loaded module libraries is 28756 KB
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Translator
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Translator (used 80 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Updates
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Updates (used 48 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Database
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Database (used 52 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library DataMiners
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library DataMiners (used 96 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Scheduler
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Scheduler (used 68 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Security
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Security (used 192 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library NetworkGrpc
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library NetworkGrpc (used 196 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Network
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Network (used 184 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Cleanup
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Cleanup (used 40 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Symbols
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Symbols (used 44 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library DynamicGroups
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library DynamicGroups (used 120 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library RemoteDeployment
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library RemoteDeployment (used 128 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Replication
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loaded module library Replication (used 204 KB)
2019-07-03 21:51:55 Information: Kernel [Thread ad4]: Loading module library Reports
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Reports (used 220 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Automation
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Automation (used 132 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library StaticGroups
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library StaticGroups (used 140 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library EmailSender
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library EmailSender (used 244 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library SNMPTrapSender
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library SNMPTrapSender (used 44 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library SyslogSender
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library SyslogSender (used 256 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library ReportPrinter
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library ReportPrinter (used 44 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library License
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library License (used 172 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Monitor
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Monitor (used 172 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Repository
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Repository (used 76 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Installers
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Installers (used 120 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library LogExport
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library LogExport (used 244 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Policies
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Policies (used 216 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Users
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Users (used 92 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library ConsoleApi
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library ConsoleApi (used 480 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library PushNotifications
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library PushNotifications (used 52 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Authentication
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Authentication (used 164 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loading module library Encryption
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Loaded module library Encryption (used 164 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Used memory before modules load and initialization is 33240 KB
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Initializing module CTranslatorModule
2019-07-03 21:51:56 Information: CTranslatorModule [Thread ad4]: Registering translator resource
2019-07-03 21:51:56 Information: CTranslatorModule [Thread ad4]: Module successfully initialized
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Initialized module CTranslatorModule (used 8 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Initializing module CUpdatesModule
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Initialized module CUpdatesModule (used 152 KB)
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Initializing module CDatabaseModule
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: Startup configuration builder builds successfully ...
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: Startup connection pool created ...
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: Builder rebuilds successfully ...
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: Connection pool recreated ...
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: CDBSetupperBase::PerformUpgradeIfNecessary: Checking if ETL DB is required
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: CDBSetupperBase::PerformUpgradeIfNecessary: ETL upgrade required.
2019-07-03 21:51:56 Information: CDatabaseModule [Thread ad4]: CDBSetupperBase::PerformUpgradeIfNecessary: Going to destroy tables because of previous fail: fact_fe_threat_event tbl_computers_aggr tbld_activethreats_status_engineversion tbld_address tbld_application_identifier tbld_application_parameters tbld_apps_installed_status_name_version tbld_apps_installed_status_vendor tbld_cause tbld_computers_comment tbld_computers_name tbld_deslockdiskinfo_status_diskfriendlyname tbld_deslockdiskinfo_status_volumelabel tbld_devicecontrol_device_event_device tbld_deviceinformation_device_status_manufacturer tbld_deviceinformation_device_status_model tbld_deviceinformation_device_status_serialnumber tbld_devicelocation_gps_status_provider tbld_diagnostics_diagnosticzip_event_data tbld_eesvirusdb_status_versiondate tbld_enterpriseinspectoralert_event_linktoeiconsole tbld_enterpriseinspectoralert_event_rulename tbld_exportedconfiguration_event_configuration tbld_firewallagregated_event_protocol tbld_hwinventory_chassis_status_description tbld_hwinventory_chassis_status_manufacturer tbld_hwinventory_chassis_status_serialnumber tbld_hwinventory_display_status_description tbld_hwinventory_display_status_manufacturer tbld_hwinventory_display_status_serialnumber tbld_hwinventory_displayadapter_status_description tbld_hwinventory_displayadapter_status_manufacturer tbld_hwinventory_inputdevice_status_description tbld_hwinventory_inputdevice_status_manufacturer tbld_hwinventory_massstorage_status_description tbld_hwinventory_massstorage_status_manufacturer tbld_hwinventory_massstorage_status_serialnumber tbld_hwinventory_networkadapter_status_description tbld_hwinventory_networkadapter_status_manufacturer tbld_hwinventory_printer_status_description tbld_hwinventory_processor_status_description tbld_hwinventory_processor_status_manufacturer tbld_hwinventory_ram_status_description tbld_hwinventory_ram_status_manufacturer tbld_hwinventory_ram_status_serialnumber tbld_hwinventory_sounddevice_status_description tbld_hwinventory_sounddevice_status_manufacturer tbld_identifiers_list_status_value tbld_ip_mask tbld_ip_subnet tbld_loggedusers_list_status_domain tbld_loggedusers_list_status_fullname tbld_loggedusers_list_status_name tbld_mac_address tbld_network_ipaddresses_status_address tbld_osinformation_edition_status_os_info_edition tbld_osinformation_locale_status_os_locale_language tbld_osinformation_timezone_status_time_zone_name_offset tbld_processname tbld_quarantine_uploadedfile_event_password tbld_quarantine_uploadedfile_event_path tbld_rdsensor_newcomputers_status_computer_identifier tbld_rdsensor_newcomputers_status_ipv4ipv6 tbld_rdsensor_newcomputers_status_mergedidentifier tbld_rdsensor_newcomputers_status_netcardvendor tbld_rdsensor_newcomputers_status_osname tbld_remote_host tbld_rulename tbld_scantargetsid tbld_security_product_status_nameversion tbld_srvsecproduct_scantargets_status_data tbld_static_groups_comment tbld_static_groups_name tbld_submittedfiles_event_username tbld_sysinspector_sysinspector_event_logdata tbld_threat_event_engineversion tbld_threatname tbld_used_license_status_licenseid_licenseproductname tbld_usergroup tbld_username tblf_activethreats_status tblf_applicationactivationmatrix_status tblf_appliedpoliciescount_status tblf_appliedpolicieslist_status tblf_appliedpolicyproducts_status tblf_apps_currentversion_status tblf_apps_installed_status tblf_apps_securitystatus_status tblf_apps_versioncheck_status tblf_audit_event tblf_blockedfiles_event tblf_certificates_peercertificate_status tblf_computer_connected_event tblf_computer_lost_event tblf_computercloningtickets_status tblf_computeridentityrecovered_event tblf_deslockcompatibilityinfo_status tblf_deslockdiskinfo_status tblf_devicecontrol_device_event tblf_deviceinformation_device_status tblf_devicelocation_gps_status tblf_diagnostics_devicecontrol_device_event tblf_diagnostics_diagnosticzip_event tblf_diagnostics_firewall_event tblf_diagnostics_hips_event tblf_diagnostics_spam_event tblf_diagnostics_webcontrol_link_event tblf_dynamicgroups_content_status tblf_dynamicgroupsmembership_status tblf_dynamicthreatdetectionanalyses_status tblf_eesevent__event tblf_eesvirusdb_status tblf_enterpriseinspectoralert_event tblf_epns_status tblf_exportedconfiguration_event tblf_filteredwebsites_event tblf_firewallagregated_event tblf_functionality_computer_status tblf_functionality_problemsdetails_status tblf_functionality_products_status tblf_hipsagregated_event tblf_hwinventory_chassis_status tblf_hwinventory_display_status tblf_hwinventory_displayadapter_status tblf_hwinventory_inputdevice_status tblf_hwinventory_massstorage_status tblf_hwinventory_networkadapter_status tblf_hwinventory_printer_status tblf_hwinventory_processor_status tblf_hwinventory_ram_status tblf_hwinventory_sounddevice_status tblf_identifiers_list_status tblf_loggedusers_list_status tblf_managed_products_status tblf_mdm_core_status tblf_mdm_enrollmenturls_status tblf_mdm_reenrollmenturls_status tblf_network_adapters_status tblf_network_ipaddresses_status tblf_network_mobile_status tblf_newcomputerenrolled_event tblf_osinformation_edition_status tblf_osinformation_locale_status tblf_osinformation_timezone_status tblf_performance_server_event tblf_performance_server_state_status tblf_qos_database_event tblf_qos_network_event tblf_quarantine_content_status tblf_quarantine_uploadedfile_event tblf_rdsensor_newcomputers_status tblf_repository_agent_status tblf_repository_epi_status tblf_repository_server_status tblf_repository_software_status tblf_scan_event tblf_security_product_status tblf_serverseatchanged_event tblf_spam_topdomains_status tblf_spam_toprecipients_status tblf_spam_topsenders_status tblf_srvsecproduct_scantargets_status tblf_static_groups tblf_submittedfiles_event tblf_sysinspector_sysinspector_event tblf_task_client_event tblf_task_client_trigger_notification_event tblf_task_detail_agentdeployment_status tblf_task_server_status tblf_threat_event tblf_threatsmute_event tblf_threatsmuteeitoera_event tblf_threatsmuteeratoei_event tblf_used_license_status tblf_webcontrolagregated_event
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Unloading module: CUpdatesModule
2019-07-03 21:51:56 Information: Kernel [Thread ad4]: Unloading module: CTranslatorModule
2019-07-03 21:51:56 Error: Service [Thread ad4]: [Microsoft][ODBC SQL Server Driver]

Cannot drop the table 'tbld_deslockdiskinfo_status_diskfriendlyname', because it does not exist or you do not have permission.
		
	

Appreciate any help you can give me.