SQL Login Archives - Page 9 of 9 - SQL Authority with Pinal Dave

SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master

March 26, 2009

SQL Activity Monitor, SQL Error Messages, , SQL Scripts

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. Error: Msg 4621, Level 16, State 10, Line…

SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account

February 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

, SQL Server Security

I just received following email from one of the blog reader. Question : “How to disable Windows Authentication?” Answer : It can not be disabled. Windows Authentication is the most secure way to login in system. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.

June 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, , SQL Scripts

Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. This is quite a famous error and I was asked to write about it by couple of readers. The reason I was not writing about this as the solution of this error…

SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’

May 3, 2007

Pinal Dave

SQL Tips and Tricks

, SQL Scripts, SQL Server, SQL Server Security

Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’