just use ssrs in native mode and develop the reports as normal which show the kpi info you want to show

I'm designing a monitoring metrics dashboard zt the moment which...

are you restoring through script? If so do you have operators and dbmail configured? You could but a send mail or notify operator tax command after the restore to email...

you should be able to configure that in the app where it grabs to logged in user at launch and stores it while the app is open then passes it...

to summarise on from the link that dskinner provided

the two accounts nt service\mssqlserver and sqlserveragent act as a sort of proxy

it allows you to change the service account as and...

the company I work for now uses entity framework, its managed by using windows auth on the connection string for only the account running iis. This user cannot login via...

nope, it is a pain staking process to go through and change the security. That is why you see so many people talking about security groups in ad which...

domain accounts and groups are two different things,

the objects to which the user cannot see will not be set at home level security. You will need to go...

easiest option would be to get your ssrs admins to give you report builder access that way you can modify them direct on the server.

if that's not an option there...

did you open the report in report builder which is the bottom option when you use the drop down menu when you hover over the report item?

or did you save...

take a look here, this is the proc we use to send out any job failures

http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures

I've done something similar, just created a blank report the way i want it then copy and pasting the XML code from the tamplate into a new blank rdl for...

also forgot to upload this ebook as well

when you open that book the title page contains a URL to a library, might be worth searching there, but not managed to find an unleashed one for SSIS...

you just need to hit the drop down arrow, which appears when you hover over the report, then you can modify a number of things and edit the actual RDL...

what account is being used as the data source account?

from what you are saying it seems like its using windows authentication with the users account?

this is the most secure way...