Sql Server 2012 enterprise "sa" login failed. Error: 18456

Question

SQL server 2012. Windows 10 Professional.

I enabled "sa" user account, and the authentication mode is set to "windows authentication and SQL server authentication". I set the password for "sa user account". but I cannot login into it. Error: 18456.

I can successfully login into windows authentication.

"sa" system administrator account status enabled.

I found many duplicate questions, but none solved the issue.

Answer 1

You need to configure the authentication mode of your SQL-Instance to "mixed" (SQL Server and Windows Authentication Mode.).

If you just changed it you need to restart the SQL-Server service.

Here's the MS-documentation and here an SO-answer.