Wednesday, April 1, 2009

Msg 4621, Level 16, State 10, Line 1 Permissions at the server scope can only be granted when the current database is master



ERROR

Msg 4621, Level 16, State 10, Line 1
Permissions at the server scope can only be granted when the current database is master







Fix/Workaround/Solution:

If you look at the database in use is AdventureWorks and when any server level permission 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/)

2 comments:

LN said...

There is a nice workaround for this problem, if the user wants to script the solution:

http://knol.google.com/k/linus-nilsson/sql-server-tips-and-tricks/g1yluc4toyn/20

Serkan SÖNMEZ said...

Thanks, for your message.