The problem is that you are using SQL server 2008. In this version the limit was still 4gb. Since SQL server 2008 r2 express the database size limit is raised to 10 GB.
We recommend that you install sql server 2008 r2 express edition and then do the following to move the database to the new sql server:
- Stop your Lansweeper service.
- Stop the service of whichever web server you are currently using: World Wide Web Publishing Service (IIS) or IIS Express.
- Take a full backup of your lansweeperdb database using SQL Server Management Studio.
- Run the Lansweeper installer on your new database server. Choose New Installation\Advanced Install and select only the database for installation.
- Do a restore of the database backup and overwrite the lansweeperdb database on the new server.
- Execute the below script in SQL Server Management Studio. This will ensure that the SQL user for your Lansweeper database is configured correctly.
use lansweeperdb
GO
drop schema lansweeperuser
GO
drop user lansweeperuser
go
execute sp_droplogin lansweeperuser
go
use master
GO
EXEC sp_addlogin 'lansweeperuser', 'mysecretpassword0*', 'lansweeperdb', [English]
GO
use lansweeperdb
go
EXEC sp_grantdbaccess 'lansweeperuser', 'lansweeperuser'
GO
EXEC sp_addrolemember [db_owner], 'lansweeperuser'
Go
- In the Lansweeper configuration files on your scanning and web server make sure that the Data Source, User ID and Password correspond with your SQL Server settings. The config files are:
%Program Files%\Lansweeper\Service\Lansweeperservice.exe.config
%Program Files%\Lansweeper\Website\web.config
- Restart your Lansweeper and web server services.