none
Log in using these credentials, but then try to impersonate the user viewing the report -Error

    Question

  • Hi Guys,

    We have service account which was add as admin on report server; was able to create connection successfully; But when we click on checkbox which states as below 

    Log in using these credentials, but then try to impersonate the user viewing the report Learn more

    it failed to connect to underlying DB unless we did below

    Made sysadmin on sql server; where report data reside;

    Else give below error

    Couldn't connect

    The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

    Hide error details 

    Cannot execute as the database principal because the principal "xyz\xyz" does not exist, this type of principal cannot be impersonated, or you do not have permission.

    Regards,

    Navin


    Navin.D http://dnavin.wordpress.com

    Wednesday, August 1, 2018 10:06 PM

All replies