Cannot create a connection to data source - SSRS 2005

  • I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group!  Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.  I thought that since this datasource was set to Windows Authentification that it would just pass it through?

    I'm pulling my hair out at this point:

    Screen Shots:

    http://www.webfound.net/datasource_connection.jpg

    http://www.webfound.net/datasource_connection2.jpg

    http://www.webfound.net/datasource_connection3.jpg

    Also As far as I know, I've given proper permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run

    An error has occurred during report processing.

    Cannot create a connection to data source 'my datasourcename'.

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

  • The user will still be prompted for username password even when using windows authentication. It just keeps you from having to manage a lot of usernames and passwords, by validating against AD. It looks like the web error messages are pointing to the Report Manager set up, the shared data source permissions are not set correctly, I have the best luck setting them from the Report Manager Web app. I think that you need to concentrate more on the permissions to access the data verses permissions to access the report.

  • well, that's a pain, I dont' want them to have to type it in, it should just pass it through.  Is there any way around this?  My other users don't get prompted though....so I don't think that's correct

  •  hi,

    i have posted some solution for the following post.so plz try those steps.it will solve your problem i suppose.

  • Reporting Services Error - I'm receiving the following error when trying to view a Reporting Services AdventureWorks report:An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'AdventureWorks'....(more online
  • Regards,

    Sudha

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

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