‎08-21-2014 09:58 PM
Solved! Go to Solution.
‎08-21-2014 10:13 PM
If you are using an SQL Server database, you need to reset the lansweeperuser database user after restoring the backup. Run the script below in SQL Server Management Studio. Restoring a backup almost always breaks the user in some way.
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
‎08-21-2014 10:13 PM
If you are using an SQL Server database, you need to reset the lansweeperuser database user after restoring the backup. Run the script below in SQL Server Management Studio. Restoring a backup almost always breaks the user in some way.
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now