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.