locked
Report Authors AD group with db_datareader rights get Login Failed error RRS feed

  • Question

  • I haved created a user who I have placed in a Report Authors AD Group, which has db_datareader acccess to the Reporting DB.

    When trying to connect the Excel client to the Reporting DB, I get a Login Failed for user: DOMAIN\USER.

    However, if I give the user direct db_datareader rights to the Reporting DB, the login works. So it seems to be something with the AD group. Any ideas?


    Rob Hardy
    Wednesday, January 25, 2012 11:38 AM

Answers

  • Hi,

    I was logged on as the user, and logging off and back on again worked. It obviously was the profile needed to pick up the AD Group...

    Thanks,

    Rob


    Rob Hardy
    • Marked as answer by EPM Tester Wednesday, January 25, 2012 12:16 PM
    Wednesday, January 25, 2012 12:15 PM

All replies

  • Hi Rob,

    Are the users added directly to the same group that has access to the Reporting DB, or are the users part of a nested AD group (below the AD group that is added to SQL)?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Wednesday, January 25, 2012 12:12 PM
  • Hi,

    I was logged on as the user, and logging off and back on again worked. It obviously was the profile needed to pick up the AD Group...

    Thanks,

    Rob


    Rob Hardy
    • Marked as answer by EPM Tester Wednesday, January 25, 2012 12:16 PM
    Wednesday, January 25, 2012 12:15 PM