Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) error

Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) error
The error happened when you set "local connection only" on the SQL Server "remote connections". The following steps will help to resolve the problem.

1. open the SQL Server Surface Area Configuration page.
2 change the remote connections to Local And Remote Connections.
3 restart the SQL Server

Others:
I had a error show that: Cannot open database "DataBaseName" requested by the login. The login failed.

After I installed the the petshop Database, I find that the petshop database is empty, and the username and password are work fine. All will be right after reinstalled the petshop database.

So, when you occuer that error, please check two items:
1. Does your database  installed completely
2. whether the username and password are right.

Thanks, hope to help you!