Browse by Tags

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)

Published 22 August 7 8:56 AM | SSQA.net

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

Filed under: sql server, security, ssms, error, login, property, ssma

Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>'

Published 18 May 7 5:56 AM | SSQA.net

You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by...

Filed under: sql server, update, users, instance, localhost, error, login