PROBLEMWhen performing an upgrade of GFI LanGuard, the following error is encountered: Failed to upgrade the database. Installation will not continue in order to avoid damaging the integrity of the GFI LanGuard Engine.
- GFI LanGuard
- All Supported environments
SOLUTIONUsing a Microsoft SQL Server database backend:
- The SQL server is not available, a connection to the SQL server is not possible because the server is not available
- Solution: Verify that the SQL server is accessible by using the Microsoft SQL Server Management Studio to connect to that server or by creating a connection to the SQL server using the Control Panel Administrative Tools Data Sources (ODBC) tool. ODBC test
- SQL connection credentials are not valid. The credentials provided via GFI LanGuard Database Maintenance dialog used when connecting to the SQL database are no longer valid (user has been disabled, password was changed,)
- Solution: Open GFI LanGuard application, go to Configuration Database Maintenance Options and specify valid credentials for that SQL server. Once the credentials are validated close the application and re-initiate the upgrade.
- SQL SA account credentials have most of the permissions. Enter SA account credentials and proceed with the upgrade process.
- The database file exists already (e.g. due to a previous failed installation attempt). The installation log "%temp%\na_na_lnssinstsql.csv" will show:
"error ","CreateDbOnSQLServerEx - Failed to create the database 'LNSSScanResults12'. Result 7. Additional error details Cannot create file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLE2012ACMP\MSSQL\DATA\LNSSScanResults12.mdf' because it already exists. Change the file path or the file name, and retry the operation..."
- Solution: Detach the database from the SQL and delete or rename the MDF and LDF files previously created for the LNSSScanResults12 database.
- The database is no longer available: the Microsoft Access database (by default located on “%ProgramDataFolder%\GFI\LanGuard XX\scanresults.mdb”) was deleted or is stored in a location no longer available (remote share point, removable drive,…)
- Solution: Verify that the Access MDB file location specified in Configuration Database Maintenance Options is valid and that the file is accessible.
If LanGuard database is created using an older SQL server version and now it is using a newer SQL server installation, the upgrade may not work. In this situation verify if possible to revert to the previous SQL server version and proceed with the upgrade process of LanGuard.