the UNC path is the path to the shared folder,

so in the example you provided it will be

restore database ######### from disk = '\\servername\Share\##.bak'

one thing I would say is create AD security groups before you start doing anything with permissions, it makes life a lot easier.

then grant the group the access it needs,...

this is working as I need it, will also invesitgate the variable route as well

public void Main()

{

...

Yep that looks like MDX to me, not my strong point I'm afraid.

i am guessing its down to having the impersonation box checked as once its connected as domain\user it then tries to run the query as domain\user1, so if domain\user1 doesnt...

current flow is

file system task to delete all files on the FTP server

for each loop with a file system task to copy all BAK files from the instance's backup drive...

do you have local admin access to the remote server?

if not ask someone who has got local admin to grant you report builder rights which will save you downloading modifying...

so SSRS is installed on your local machine where you are trying to get the reports from? or are they on a remote server?

I take it your running the same account for both the server and agent?

please post a screenshot of the settings for the datasource dstest2

that maybe down to permissions, I've seen that before after a restart of the agent it still doesn't work

can you impersonate the SQL agent account and try sending a mail...

have you checked the execution plan for the query to see if anything stands out

when you created the r2 profile did you have ssms connected to multiple servers?. You might have opened the wrong servers mail config wizard hence why its showing on the...

you could set the database to off-line / read-only after the restore which will stop the users logging in.

then set the database to single user, then read-write and run in...

develop drill down reports.

basically in my solution I'm working on at the moment it gives high level information first, then you click on a particular metric and it loads a...