SQL Server 18452 login error cannot connect to the server: Message 18452, level 16, status 1 [Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa 'Login Failed. Cause: the error is not associated with a trusted SQL server connection because SQL server uses the "Windows only" authentication method, therefore, you cannot use the Logon account of SQL Server (for example, SA) to connect,
The solution is as follows:
1. Set to allow SQL Server login (this is basically useful) operation steps: 1. In Enterprise Manager, expand SQL Server group and right-click SQL Server server name 2. Select "attribute" 3. Select Security tab 4. Under "authentication", select "SQL Server and Windows" 5. OK, and restart the SQL Server service.
2. If the problem persists, check whether the SA user is Enabled: 1. Right-click the SA user to open the attributes. 2. Select the "status" tab and select enable in login.
Sa is not enabled. It is easy to appear when the database is used at the beginning and is often unknown.
Because XP is installed on a personal PC, the SA account is usually not started during database installation. It is useful.