Shaival 0 Posted December 5, 2017 Share Posted December 5, 2017 Dear ESET Team, User has remove only Microsoft SQL Server from ERA Server unknowingly & now user can't log in to web console. It gives error Login failed: Connection has failed with state 'Not connected' Is there any way to resolve this issue without reinstall all the component of ERA? Link to comment Share on other sites More sharing options...
ESET Staff MichalJ 434 Posted December 5, 2017 ESET Staff Share Posted December 5, 2017 As ERA is fully dependent on the SQL (all of the data, including user logins is in there), it won't work. Why user did that? Link to comment Share on other sites More sharing options...
Shaival 0 Posted December 5, 2017 Author Share Posted December 5, 2017 someone has remove unknowingly but fortunately we had taken backup of certificates & ERASQL Database so is it possible to restore from it. Link to comment Share on other sites More sharing options...
j-gray 35 Posted December 5, 2017 Share Posted December 5, 2017 SQL Express installer should be in the folder with the rest of the ESET install packages (e.g. Apache, RDSensor, etc.). If not, you can download the same version (2008 R2 Express SP2) directly from Microsoft. You will most likely want to install SQL Server Management Studio and use it to restore the database. Link to comment Share on other sites More sharing options...
ESET Staff MartinK 378 Posted December 5, 2017 ESET Staff Share Posted December 5, 2017 Fist of all, I would recommend to check, whether database data/configuration was also removed during installation. If it is still present, installing the same version of SQL Server should be enough to make it work. If previous steps won't work and you have full backup of ERA database, follow migration steps described in ERA documentation. Technically you will have to install SQL server of your choice (but must be supported by ERA), restore database from backup, configure accounts that will be used by ERA instance to access data, and re-configure ERA so that it can access data (i.e. adaptation of connection string to new database configuration). Link to comment Share on other sites More sharing options...
Shaival 0 Posted December 12, 2017 Author Share Posted December 12, 2017 @MartinK Thanks for your recommendation, I try to follow steps which is recommend by you but unfortunately I receive an error. I also contact at local ESET representative and use the standard support channels they also tried a lot but unfortunately the problem is not resolved and we have to reconfigure ERA server again. Link to comment Share on other sites More sharing options...
Recommended Posts