Karatas, FERHAT
I would love to change the world, but they won't give me the source code!
Property IsLocked is not available
4.9.2009 10:40:49 - Filed under : SQL
Property IsLocked is not available for Login '[DBName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

Solution 1 : Restart computer

Solution 2 :
I ran into the same issue today when I installed an instance of SQL 2005 using Windows Auth. mode.  After the install I switched the server over to SQL and Windows Auth mode and ran into the 'sa' problem.  I ran the following command and then could see the properties of 'sa' within management studio.
alter login sa
with password = 'yourpwd' unlock,
check_policy = off,
check_expiration = off

Keywords : Sql login, islocked, insufficient
with 0 comments

What do you think ?
Security Code 5270
Check S. Code
Home Page