login failed

Question

Cannot open user default database. Login failed. Login failed for user how to fix this error, I made a mistake and deleted the database or the mdf, how do you fix this?

David Smith · Answer

I fix the problem, for some reason there a connection still open, so I went to task manager and end the task for the sqlsever.exe. I didnt get the error no more. Very weird. I restarted my computer 3times and I still kept getting that error. So something told me to check task manager . Its working.

Amit Choudhary · Answer

hi friend, i think this is your question.. you should have backup of your database. if you have then add that file to your app_data folder and then connect again. if don't have backup try any recovery tool. it not related to programming you have to back it up [mdf] file.

David Smith · Answer

How to get to the option button in MS visual studio,Im using c# , Im not working in sql,Im using sql commands

Lalit M · Answer

check here http://benharrell.wordpress.com/2007/01/15/cannot-open-user-default-database-login-failed-login-failed-for-user-username-microsoft-sql-server-error-4064/ http://benharrell.wordpress.com/2007/06/18/update-cannot-open-user-default-database-login-failed-login-failed-for-user-%E2%80%98username%E2%80%99-microsoft-sql-server-error-4064/

login failed

Cannot open user default database. Login failed.Login failed for user

Answers (4)

Cannot open user default database. Login failed.
Login failed for user