Restore Unity to UAT Security Rights

After you restore, you have to give the sql user uat_user dbo permissions to the newly restored db.

In sql server management studio you connect to the server. Then under Security-> Logins you righ click the account you want to give permission to and select Properties. In the properties window there is a tab called User Mapping. On that tab you highlight the database you want to give the user permission to and in the bottom half of the screen you select dbo. Then just save.