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.
kdschoolAsked:
Who is Participating?
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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
All Courses

From novice to tech pro — start learning today.