Browse by Tags

Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Published 22 August 7 8:56 AM | SSQA.net

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

Filed under: sql server, security, ssms, error, login, property, ssma

Error: Property MustChangePassword is not available for login

Published 7 August 7 9:50 AM | SSQA.net

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

Filed under: sql server, ssms, users, login, password, property, sqlsmo