During my life of ASP .Net development I came across some issues which I am trying to bind at one place with the solution for other people.
Even though this is rare but there can be scenarios where you may have to rename the SQL Server database along with the physical database files ( i.e. MDF and LDF )