Fix : Error 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

Recently i have faced this error.
I have searched a lot on the net and got this solution which is really working.

Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

Fix/Solution/Workaround:
Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”
to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.

Run following script in SQL Analyzer to change the authentication

ALTER LOGIN sa ENABLE
GO
ALTER LOGIN sa WITH PASSWORD = ‘’
GO
 

OR

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties. On the General page, you may have to create and confirm a password for the sa login. On the Status page, in the Login section, click Enabled, and then click OK.