→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BentO
Engaged Sweeper II
Hello

Trying out LanSweeper.

1 - Installed LanSweeper, localDb.
2 - Pasted Trial Key.
3 - Started LanSweeper and resctricted access to a AD group (yes, I'm member).
4 - Restarted the pc.

After restart - the localDb service will not start "Service cannot be started. The handle is invalid" ?

----

Next step:

A - Uninstalled LanSweeper and all it's components.
B - Restarted PC.
C - Install LanSweeper again.

Now LanSweeper cannot be installed, because .... the localDB service cannot start ?!?!?!?!

---

Questions

- What causes the localDB not to start in the first place ?

- What is not uninstalled / removed completely, when uninstalling LanSweeper ?

1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
When you uninstall Lansweeper and were using the LocalDb database provider, SQL LocalDB 2014 will be left behind on your machine. This is because we cannot determine with absolute certainty that no other application was making use of SQL LocalDb, and we could otherwise inadvertently break another application.

Ordinarily, if the LansweeperLocalDbService was able to start during your initial installation, I would expect it to be able to start successfully in the future as well. During the start of this service, your SQL LocalDb instance is created, your Lansweeper database is created and the user you used to install the application with is given admin rights on the instance. It is possible to get a "handle is invalid" error if you renamed the computer, or if the user you installed the application with no longer exists or is corrupted (e.g. userprofile issues).

As an alternative, you could install Lansweeper using SQL Server. The free Express edition can be used:

  • Download and install SQL Server Express: https://go.microsoft.com/fwlink/?linkid=866658
  • Optionally, but recommended, install SQL Server Management Studio: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
  • Configure your SQL Server instance to host your Lansweeper database (straightforward): https://www.lansweeper.com/knowledgebase/sqlserver-enable-mixed-authentication/
  • Perform an advanced installation of Lansweeper and connect to your new SQL Server instance: https://www.lansweeper.com/knowledgebase/installing-lansweeper/#heading2

View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
When you uninstall Lansweeper and were using the LocalDb database provider, SQL LocalDB 2014 will be left behind on your machine. This is because we cannot determine with absolute certainty that no other application was making use of SQL LocalDb, and we could otherwise inadvertently break another application.

Ordinarily, if the LansweeperLocalDbService was able to start during your initial installation, I would expect it to be able to start successfully in the future as well. During the start of this service, your SQL LocalDb instance is created, your Lansweeper database is created and the user you used to install the application with is given admin rights on the instance. It is possible to get a "handle is invalid" error if you renamed the computer, or if the user you installed the application with no longer exists or is corrupted (e.g. userprofile issues).

As an alternative, you could install Lansweeper using SQL Server. The free Express edition can be used:

  • Download and install SQL Server Express: https://go.microsoft.com/fwlink/?linkid=866658
  • Optionally, but recommended, install SQL Server Management Studio: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
  • Configure your SQL Server instance to host your Lansweeper database (straightforward): https://www.lansweeper.com/knowledgebase/sqlserver-enable-mixed-authentication/
  • Perform an advanced installation of Lansweeper and connect to your new SQL Server instance: https://www.lansweeper.com/knowledgebase/installing-lansweeper/#heading2