Post reply

Srss security issue

  • December 19, 2013 at 7:42 am

    #281409

    hi guys

    trying to setup an srss site for a sql 2012 instance.

    i can develop and publish the reports to the srs site, but when i try to view the report i get a data source error..

    "Cannot create a connection to data source ' Data source for shared dataset'"(rsErrorOpeningConnection)

    the report views fine when opened in visual studio,

    i have set my self up to have full admin on the srs site,

    the data source is created to use windows authentication, and i am a domain admin

    does anyone have further ideas what i need to change?

    thanks

    mal

  • December 19, 2013 at 8:04 am

    #1674832

    when i check the sql event log i see ANONYMOUS LOGON attempts each time i run the report

  • December 19, 2013 at 8:12 am

    #1674838

    this sounds like a kerberos issue. I would check if the proper SPN is created and whether the SSRS service account has delegate permissions

    have a look at this article

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • December 19, 2013 at 8:24 am

    #1674849

    thanks robert, this sounds fun!

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

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