if you do need to one day move the SSRS database from one server to another, you will need the ssrs encryption keys.

when you configure SSRS, the last step should...

along with trusts in place, try using the FQDN so \\server.domain.com\share

the data source is set to connect as domain\username, once the connection is made, it then switches from domain\username to domain\vinod.saraswat for example

if that second account doesnt have the access...

Thanks Daniel, I was on the right track. Just copied the tamplate RDL I had created and put it in the correct folder now I dont have to modify the...

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...