ERROR:Property IsLocked is not available for Login

Error:

Property IsLocked is not available for Login ‘[login_name]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Solution:
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 [login_name] with password = ‘yourpwd’ unlock, check_policy = off, check_expiration = off

or
when you create user you need to uncheck <Enforce password policy>,<Enforce password expiration>.

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>