Connect to the server
Server: message 18452, level 16, status 1
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa 'login failed. Cause: it is not associated with a trusted SQL Server connection
This error occurs because SQL Server uses the "Windows only" authentication method. Therefore, you cannot use the logon account of SQL Server (for example, sa) to connect to SQL Server. The solution is as follows:
Set to allow SQL Server login (this is basically useful)
Procedure:
1. In Enterprise Manager, expand "SQL Server Group", right-click the name of the SQLServer Server
2. Select "properties"
3. Select the "security" tab.
4. Under "authentication", select "SQL Server and Windows"
5. OK, and restart the SQL Server service.
When "sa" is used to log on to SQL Server2005, the following error is reported:
Login failed for user 'sa '. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
Solution:
(1): Enter the controller in Windows authentication mode
(2) "security" = "" user "=" double-click User sa (pop-up attribute dialog box) = "status"
(3) change the status to enable and exit the controller to log on again (user authentication mode ).
18452 error: When I first installed SQL server, I did not select windows and SQL dual identity login options. I can simply find the correct location.
By the way, let's share the 18456 error. There are basically three reasons: Your user name is wrong; your password is wrong, and both your user name and password are wrong.