Error connecting Sql Server from asp.net : User not associated with a trusted SQL Server connection.

Reason:
SQL Serversecurity authentication is set to Windows only.

Try this:
Set it to sql and windows mode. Right click on SQL Server root -> Properties -> Security -> Change mode and save.

Restart the server. you are good to go now.