User "sa" Login Failed. This user is not associated with a trusted SQL server connection

You can use the following solutions.

 

1. enable SQL Serve Authentication

SQL Server Management studio -- Object resource manager -- Right-click your server (. \ sqlexpress or localhost) -- properties -- Security -- Server Authentication -- SQL Server and Windows Authentication mode. Then check whether SA logon is enabled.

2. SQL Server Management studio -- Object resource manager -- Security -- login name -- Right-click sa -- Property -- status -- enable -- General -- Set Password

3. At last, remember to restart the sqlserver service, instead of shutting down sqlserver2005 and restarting it.Service