[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 993
  • Last Modified:

sql server 2010 deleted database, restored it and now can't login error 4064

I deleted a database and then restored it from a symantec back up.  Now I get an error message trying to open SQL server manager that says

Cannot open user default database, login failed.  Login failed for (servername ) admin. Microsoft SQL error 4604

Can anyone tell me how to fix this.  I think the datbase is corrupted even on the restored version.  SQL server 2008.
0
kdschool
Asked:
kdschool
  • 3
  • 3
1 Solution
 
plusone3055Commented:
have you first created a new login and added it to the database since the restore ??
0
 
Sam SawalhiIT ConsultantCommented:
Hello,

SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user

http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/
0
 
kdschoolAuthor Commented:
I cant' get on the SQL Manager at all or see any of the databases.  Also when I tried solution 2 no databases are in the list so I hit browser for databases tyring to get to master and I get the same error message.  It won't let me browse.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
kdschoolAuthor Commented:
Everything was fine till I removed that database.
0
 
kdschoolAuthor Commented:
Very quick and great response. Saved me.
0
 
Sam SawalhiIT ConsultantCommented:
You are welcome, and I'm very happy that I could help...Cheers!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now