Wednesday, February 15, 2012

Error while connecting to analysis services data source from reporting services

  • I am trying to connect to an analysis services data source from reporting services.
  • Analysis services is on a different domain. When I try to run the reports I get the error
  • "Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https. "
  • Any ideas on what is the workaround?

    Try this:

    on the reporting server, create a user ie. report and in IIS let the Reports and Reportserver run as the report user you just created. On the Analysis server, create that same user with the same password. Add that user to the Analysis cube. Thats it.

    I have added my report user on the domain and also locally on the server. I don't think you need the user in both places but you can test as a local user as see what happens

    |||When I modified the user in the report server application poll, I'm getting "service unavailable" error when connecting to reports|||

    Leave the app pool as Network Service,

    In IIS, Report/Reportserver properties ->directory security, check enable anonymous access and type in your user name and password

  • No comments:

    Post a Comment