日存档: 2010年5月21日

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>.

MSSQL2K5 install WMI error2147746132(0x80040154)

I got follow error when installing MSSQL2K5 on windows2003 SP2,

the SQL server SYSTEM configuration checker cannot be executed due TO WMI configuration ON the machine DESHKSDOWA029 ERROR: 2147746132(0x80040154)

I troubleshoot this error for over 2 days, but no luck. and we consolut some Microsoft guy, this is a old issue with WMI, here is the root cause and solution,

CAUSE:
————————–
C:\Windows\Systeem32\WBEM folder was missing permission for “SystemName\Users” account
  
  
RESOLUTION :
————————–
Added “SystemName\Users” account under ‘C:\Windows\Systeem32\WBEM’ folder.
Provided  Provided “Read & Execute” permission on  it.
After this, we were able to complete the SQL Server installation.

and this is a very helpful solution, I tried a lot of ways to re-register the WMI classes or install WMI other conponent, but all were helpless. I’m happy I got this solution so I can’t wait to share this on my homepage. hope it can help you as well.