User-166373564 posted
Hi,
when I try to open the database the connect stops and an error message appears saying 'login failed for user ollie/ollie'
When a connection attempt is rejected because of an authentication failure that involves a bad password or user name, a message similar to the following is returned to the client: "Login failed for user '<user_name>'.
Please refer our msdn document, it will give a good guide to troubleshoot
Troubleshooting: Login Failed for User 'x' in SQL server 2008 R2,
hope it helps you,
With regards