Error: Cannot create a connection to data source 'dsMIS'

  • Shaykh

    SSC-Addicted

    Points: 401

    The report runs fine locally but when its deployed to the report server and run from there the following error occurs: "Cannot create a connection to data source 'dsMIS'". The data source settings on the report server match that on the local machine. They are set to "Credentials stored securely in report server". Why am I still unable to run this report from the report server? 

      • Cannot create a connection to data source 'dsMIS'.

      • This topic was modified 4 days, 18 hours ago by  Dave Convery.
    • Sue_H

      SSC Guru

      Points: 89729

      Shaykh - Wednesday, September 5, 2018 8:14 AM

      The report runs fine locally but when its deployed to the report server and run from there the following error occurs: "Matalan Overview - Report Manager Cannot create a connection to data source 'dsMIS'". The data source settings on the report server match that on the local machine. They are set to "Credentials stored securely in report server". Why am I still unable to run this report from the report server? 

        • Cannot create a connection to data source 'dsMIS'.

        Because there is a difference of some sort between the local server (do you mean a SQL Server instance on your PC) and the report server.
        Instead of assuming they are exactly the same, it often helps to assume there is a difference and then try to find the difference.
        The "credentials stored security on report server", those credentials need to be the same. The data sources need to be the same. The permissions for those stored credentials need to be the same and if used for unattended execution that account needs permissions to log on locally and logon as a batch job.
        You can usually find a bit more information about the error in the Reporting Services log file:
        Report Server Service Trace Log

        Sue

        • This reply was modified 1 month, 3 weeks ago by  Sue_H.
        • This reply was modified 1 week, 5 days ago by  Dave Convery.

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

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