Cannot open database test requested by the login. The login failed. Login failed for user xyzASPNETMost times, its not a login issue, but an issue with creating the database itself. Acronis Anti Malware Scan Cd 2012 Set Up Keyboard Shortcuts. So if there is an error creating your database, it would not be created in the first place. In which case if you tried to log in, regardless of the user, login would fail. We have Windows 2008R2 with Exchange 2010. A user logged in and they receive a message The User Profile Service Failed the Logon. User Profile Cannot Be Loaded. I can. This usually happens due to logical misinterpretation of the db context. Visit the site in a browser and REALLY read those error logs, this can help you spot the problem with you code usually conflicting logic problems with the model. In my case, the code compiled fine, same login problem, while I was still downloading management studio, I went through the error log, fixed my db context constraints and site started running fine. Watch this video to Fix the Error User Profile Service failed the logon. User profile cannot be loaded. Got your issue fixed Tweet it to your friends.