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
|