Sql – Renaming Computer name on SQL Server 2008 R2

First, this is really a standard SQL Server backup. TFS data is there, but that's not relevant.

Second, in SSMS, open your maintenance plan for editing. Make sure that you have logging enabled, and then run the plan. This will create text files in your /LOG folder under the SQL Server installation folder. Check that and it will have more details about what specifically is wrong. Post that and we can help you debug the issue.

Under Security > Logins, create a new login, and in the User Mapping section, tick the two databases, and for each select db_datareader role membership.

This will provide read access to all the data in each DB.

If you want to do it in script, the GRANT command is where you need to start.

An alternative approach is provide access to data through Stored Procedures, and rather than giving them Read permissions to the raw data, grant them Execute permissions to your selected SProcs.

Final Embellishment: If setting up these permissions is fiddly, you might want to create your own Database Role, and you can assign these permissions as described above. The for each user (now and in future), you can simply assign them to that role.