Do both databases have the same name?
How can you connect to the DB restored on the NM (Mixed Mode or Windwos authentication only)?
In case of mixed mode: Did you add all SQL user from the original db to the new db? If not, the SQL login most probably won't work anymore....