Login Failed for User (Microsoft SQL Server, Error: 18456)

You have changed password for login user and still not able to login ?

you are getting error 18456, then you need to change the server setting and restart the Sql server


To know when Password was changed:

SELECT name AS [Login Name] , sid AS [SID] , type_desc AS [Login Type] , create_date AS [Created Date] , modify_date AS [Last Modified Date] FROM

 sys.sql_logins WHERE [name] = 'sa'


Change Password:

ALTER LOGIN [sa] WITH PASSWORD=N'Password@1', CHECK_POLICY = OFF