This thread is a bit older, but wanted to add a tid bit from a case I just got.
If you happen to rename the database in SQL Server, and do not remember the original geodatabase name, you can check that in the database_name column of your sde_table_registry table. That table hard codes the name of the database as it was when the geodatabase was created.