Browse by Tags

Error: Property MustChangePassword is not available for login

Published 7 August 7 9:50 AM | SSQA.net

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

Filed under: sql server, ssms, users, login, password, property, sqlsmo

Script to find out all the groups contain in the login token for every server principal

Published 17 July 7 10:44 AM | SSQA.net

The following query will get you the information to find out the groups that contain user login token on that server principal: SELECT name , usage , type FROM sys.login_token ORDER BY usage , type , name go To find any Windows principal in the token...

Filed under: sql server, security, users, login, script, token, principal

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