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 yorum:

LN dedi ki...

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 dedi ki...

Thanks, for your message.

Visual Studio 2017'de Devexpress 17.2.5 Toolbox görünmüyor

Visual Studio 2017 Toolbox'ı üzerinde Developer Express componentlerini göremiyorsanız aşağıdaki komutu çalıştırmak işini görecektir. (...