Browse by Tags

• error
• login
• password
• security
• SQL Server
• sqlsmo
• ssma
• users

• Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

  One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ Read More... Posted Wednesday, August 22, 2007 11:56 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, SSMS, error, login, property, ssma

• Error: Property MustChangePassword is not available for login

  If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges or if you are the Read More... Posted Wednesday, August 08, 2007 12:50 AM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, password, login, property, users, sqlsmo