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
|