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)
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)
------------------------------
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=IsLocked&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
If that SQL Instance is defaulted with CHECK_POLICY & CHECK_EXPIRATION on login properties you wouldn't be able to open using SSMS, to accomplish the task of changing default database for the logins firstly you need to run the following statement:
alter login sa [X] with password = 'yourpwd' unlock, check_policy = off, check_expiration = off