none
Issue with SSRS Manage Data Source RRS feed

  • Question

  • Hi 

    We have installed SQL Server 2012 + SP2 , SharePoint Server 2013 and Project Server 2013 on same Server

    Facing issue with creating Data Source in SSRS Reports

    When i click on Test Connection it throws The target principal name is incorrect. Cannot generate SSPI Context

    Any Suggestions

    Regards

    Santosh

    Friday, September 26, 2014 1:00 PM

All replies

  • Hello,

    This article will surely help you

    http://support.microsoft.com/kb/811889


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Friday, September 26, 2014 1:07 PM
    Moderator
  • Hi Guillaume 

    Thanks for the reply

    I had a glimpse on above link.

    1) Above link says need to perform below steps. Where we need to run below steps (SQL Server or AD Server)

    Sorry for asking basic question

    • Click Start, click Run, type Adsiedit.msc, and then click OK.
    • In the ADSI Edit snap-in, expand Domain [<var>DomainName</var>], expand DC= <var>RootDomainName</var>, expand CN=Users, right-click CN= <var>AccountName</var>, and then click Properties
    • In the CN= <var>AccountName</var> Properties dialog box, click the Security tab.
    • On the Security tab, click Advanced.
    • In the Advanced Security Settings dialog box, make sure that SELF is listed under Permission entries.

    2) Link talks about Windows Server 2000 version. Is this applicable for 2008 ?

    Regards

    Santosh


    Sunday, September 28, 2014 2:55 PM