Search code examples
sql-server-2012windows-10sa

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

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. enter image description here

I can successfully login into windows authentication.

"sa" system administrator account status enabled. enter image description here

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

Solution

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