Connecting to Access DB kept on FTP Server from Report Server 2008

  • Hi,

    I have created one report which takes data from Access database kept on ftp server.

    When I run report from BIDS, it works fine. Now I have deployed the report on reporting server and now it says could not establish connection with the datasource.

    Is there anything needs to be configured on Report Server too.. As far as datasource confirguration, I have verified the stuff and everything is looking ok.

    Anybody has any idea on what else need to be check in case of access database is kept on ftp server?

    Regards,

    Saseen

    :rolleyes:

  • Does the Report Server Service account have permissions to connect to the FTP location? What are you getting for an error?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • Hi Jack,

    Reporting Services account do have access on FTP server.... I don't know whats going on wrong..! :doze:

    :rolleyes:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply