Thursday, March 8, 2012

Cannot create a connection to data source !!!!!!!

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 sufficient 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 'datasourcename'.
  • For more information about this error navigate to the report server on the local server machine, or enable remote errors
  • no it usues whatever account iis is running under.

    IUSR_something I think.

    if you want use integrated auth you need to use impersonation.

    |||ok....then how do incorporate personalization in Reporting Services! I don't see anything on that...I think you're referring to .NET, I'm talking about Reporting Services 2005|||I posted this in the wrong forum by accident..I'll move it to Reporting Services..sorry
  • No comments:

    Post a Comment