Forum Discussion

gesgin's avatar
gesgin
Icon for Helper I rankHelper I
8 years ago

The credentials provided for the SQL source are invalid

Hi,   We have a test PBI Server and we're successfully saving our reports into the related report server url. There's a consulting firm that works with our company and they need to save some report...
credential
Anonymous's avatar
Anonymous
Not applicable
8 years ago

It looks like a scheduled refresh has been setup (to keep the data within the report up to date), and when the refresh plan runs Report Server can't connect to the dats source. You need to configure the authentication for the data source(s) that are used in their report.

 

Click the ellipsis on the report tile (that you see in the Report Server portal) and go to Manage. Then go to data sources. For each data source which they've used, you need to configure the authentication correctly. You have a choice of either using:

 

  • Integrated authentication (e.g. where the end users credentials are passed across to the data source), however you need to of configured Kereberos authentication on your network first.
  • Dedicated user account
    • Using a Windows account
    • Using a SQL Server login

 

  • gesgin's avatar
    gesgin
    Icon for Helper I rankHelper I
    8 years ago

    Thank you for your answer Anonymous

    But these guys could not save any report to the server, so there's no report or data source in related folder that I can see in the portal. Meanwhile, the database that they are using is different from ours.

     

    The db name I've mentioned in first message is the one that exists in PBI Test Server and nobody uses a table from that db in their reports.