I have received comment from Radha Goswami on my previous blog article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users. Radha is facing following error when she is tring to grant permission to login.
Msg 4621, Level 16, State 10, Line 1
Permissions at the server scope can only be granted when the current database is master
Following image is I have recreated based on the above error message.
If you look at the database in use is AdventureWorks and when any server level persmission has to be granted the database in context should be of master database. Change the database used to master and it should fix the error.
Reference : Pinal Dave (http://blog.sqlauthority.com)