How to Fix Login Failed for User (Microsoft SQL Server 2017, 2019, Error: 18456)

Aug 14, 2023

SQL Server 2017 (Login Failed for User sa, Error:18456)
SQL Server 2019 (Login Failed for User sa, Error:18456)

Content

0.742 -> In this video we will solve to Login Failed for User (Microsoft SQL Server 2017, 2019, Error: 18456) Error

4.758 -> Lets see the error

14.565 -> Open combobox and select «Windows Authentication» and click «Connect» button

23.431 -> Open «Security/Logins» in «ObjectExplorer» than right click «sa» user and click «Properties» button

35.919 -> Click «Status» in the opened «Login Properties» panel and change the «Login» as «Enabled». Then click «OK» button

44 -> Click «Refresh» symbol in «Object Explorer»

48.836 -> Right click on Server. Then click on «Properties» from panel that opens

54.729 -> Click on «Security» page

58.263 -> Change the mode as «Sql Server and Windows Authentication mode». Click «OK» button

64.812 -> Click «OK» button

74.487 -> Right click on server and click «Restart Server» button

83.625 -> ..: waiting for restart :..

94.28 -> Click to Disconnect button then click to Connect button

98.426 -> Select «Authentication - Sql Server Authentication»

102.263 -> Type Login and Password

Source: https://www.youtube.com/watch?v=GDoOg_oeKEI