Post reply

SSRS - Cannot create connection to data source

  • August 5, 2010 at 9:34 am

    #224377

    Hi all,

    Have created a report based on an SSAS cube.

    Works fine on my local machine in preview but when I deploy it and try to run it on our report server I get this error message:

    "An error has occurred during report processing. (rsProcessingAborted)

    Cannot create a connection to data source"

    The report server and the anaysis server are on different servers.

    Any one help ?

    TIA

  • August 5, 2010 at 9:41 am

    #1202866

    Is the service account running your SSRS instance set up as a user in your database?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 5, 2010 at 10:46 am

    #1202935

    Is that a user on the SSAS server sql instance John ?

    The SSRS server logins as SERVER\Administrator

    The SSAS server; All services use a setup account called ZZ_SQL_<Servername>

    Since I wrote the post i have done some poking around and it looks like it has to do with authentication between the 3 computers involved.

    <USER> talks to <SSRS> and then <SSRS> talks to <SSAS>

    I am reading about a 'double hop' problem.

    Any help is much appreciated. Wish people would post complete solutions instead of just saying 'Solved it' 🙂

    Promise I will on here when i get it working.

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

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