It is recommended that you update your Lansweeper installation on a regular basis, to ensure that you have the latest available patches installed and access to any new features that have been released. Any update should be run on the machine hosting the web console as well as any scanning server hosting the Lansweeper Server service, as explained in this knowledge base article. The first scanning server to be updated will update the database as well, so the update does not need to be run separately on the database server.
If an update includes database changes, your scanning server will run a number of scripts on the database to implement the changes. If you have a large database, the scripts may take a while to complete and you may see a message similar to the one below for the duration of the update. The message below indicates that your web console is on a higher Lansweeper release than the database and is waiting for the database update scripts to finish processing. It is recommended that you wait at least half an hour and refresh the web console to see if the execution of the scripts is progressing as expected. If the message below does not change after half an hour however, this may indicate that your scanning server is not on the same Lansweeper release as the web console or that there is an issue with your scanning server connecting to and running the scripts on the database.
If the update message does not disappear on its own, do the following:
- Double-check the URL you are accessing to determine which machine is hosting your Lansweeper web console. If localhost is listed in the URL, your console is hosted on the machine you're accessing the console from. If a computer name or IP address is listed in the URL, your web console is hosted on the machine whose name or IP is included in the URL. In the example below, the console is hosted on computer LAN-001.
- Stop the web server service in Windows Services on the machine hosting your web console. Keep in mind that this will log everyone out of the console. Your web server service is either IIS Express or World Wide Web Publishing Service (IIS).
- Stop the Lansweeper Server service in Windows Services on your scanning servers.
- On the machine hosting your web console, open the Website tab of the tool below and verify which database your web console is connecting to. If your database is hosted in the Microsoft SQL Compact database server, your connection string will just be a reference to an .sdf file. If your database is hosted in Microsoft SQL LocalDB or Microsoft SQL Server, the string will include a Data Source (SQL instance name), Initial Catalog (Lansweeper database name), username and password.Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe
- On machines hosting the Lansweeper Server service, open the Service tab of the tool below and ensure that the database connection string in the tool matches the one used by your website. If your database is hosted in SQL Compact, your connection string should already be correct. If your database is hosted in SQL LocalDB or SQL Server though, the SQL instance name, username or password used by the service may be incorrect. Keep in mind of course that, if your scanning service is not on the same machine as your database, you will need to replace any localhost references in your connection string with the name or IP address of your database server.Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe
- Restart the Lansweeper and web server services in Windows Services.
- Download the latest Lansweeper installer through this link.
- Run the installer on the machine hosting the web console *and* one of the machines hosting the Lansweeper Server service. If available, choose the Upgrade option. If the Upgrade option is not available, close the installer.
- If the update message still doesn't disappear after waiting half an hour and refreshing the web console, look for and resolve database connection failures in the log below, found on the machine hosting the Lansweeper Server service. If the Lansweeper service cannot connect to the database, it cannot run the database update scripts. There are articles in our knowledge base on resolving "login failed", "network-related or instance-specific" and "database file may be corrupted" errors you may find in the log below. You can find these articles here, here and here.Program Files (x86)\Lansweeper\Service\Errorlog.txt
- Once the update message has disappeared, update any remaining servers hosting the Lansweeper Server service as well. You can do so manually, by running the latest Lansweeper installer on the servers, or silently, by following this procedure.