locked
SQL server 2005 reporting services error RRS feed

  • Question

  • We have two servers - SQL server 2005 with Windows 2003 server OS
    Server A :
     All SQL related server services running under domain account -
    Error from reporting server - Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <ip>]

    Server B : 
     All SQL related server services running under local account (Example - servername\sql)-
    Error from reporting server - Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]

     Please provide ur inputs to solve this.Thanks in advance

     

    Wednesday, May 20, 2009 11:50 PM

Answers

  • Managed and solved it by providing necessary permissions at SQL level and OS group member  addition
    • Marked as answer by Rajganesh.dba Saturday, June 13, 2009 4:11 AM
    Saturday, June 13, 2009 4:10 AM