When you restore a MSSQL database from a .bak, the user permissions at a database may be watered down.

We are bumping into as much and are finding we need to reapply the execute permission to users within remade databases. Such inspired this blog entry.