→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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

Hello community,

I am following this step-by-step

https://www.lansweeper.com/knowledgebase/move-lansweeper-to-different-server/

Everything was going ok untill the step 6, at this link: 

https://www.lansweeper.com/knowledgebase/restoring-your-installation-from-a-backup/#heading2

When I try to drop the lansweeperuset

BEGIN
DROP USER lansweeperuser
END;

I am getting this error:

Msg 15284, Level 16, State 1, Line 19
The database principal has granted or denied permissions to objects in the database and cannot be dropped.

 

Can anyone please tell me what I did it wrong?

Ty

1 REPLY 1
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

Do make sure that the script is executed with a user that has sysadmin rights, as the error seems to indicate that there is a lack of permissions.