SQL Server Error: 18456. User "sa" Login Failed

Today, after I installed the database, I encountered a Problem When configuring the obdc of the data source. As follows:

The reason is that the database is not connected successfully. When performing the following link,

 

Unexpected situation

 

 

 

 Solution:

 

 

1. Open the database-log on to the database as a Windows User

 

 

02. login name -- double-click SA (Open attributes)

 

 

03. General -- set the password -- OK

 

 

04. Status -- Logon: enabled -- OK

 

 

05. Right-click the server name -- Properties

 

 

06. Security-select SQL Server and Windows Authentication Mode-OK

 

07. Right-click the server name -- restart -- close the database connection and exit the program -- use SA to log on to the database -- Solution

Note:

 

If the preceding method is invalid, go to the Start menu -- Microsoft SQL Server 2008 -- Configuration tool -- Microsoft SQL Server 2008