One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ...

If you have stumbled with the error ''Error: Property MustChangePassword is not available for login..'' or same as the picture show below: To solve the issue either you have to take out the ''enforce password policy'' using SA privileges or if you are the database owner then delete and re-create the user, with the “enforce password policy” box ...

declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked' ) AS IsLocked , LOGINPROPERTY ( @name , 'IsMustChange' ) AS IsMustChange , LOGINPROPERTY ( @name , 'LockoutTime' ) AS ...