Thanks for your help in advance!
Windows NT 2003 Web Server
IIS Website - Windows Authentication
IIS App Pool - Network Service
Also hosts SQL 2005 Reporting Services
Windows NT 2003 Database Server
MY_ACCOUNT = Administrator, SA on the SQL 2005 Database Server
Using 'Report Services Configuration Manager', I have my Database Setup using an account, say MY_ACCOUNT
When MY_ACCOUNT is and Administrator on the Web Server (via Administrator Group), I can enter the Report Server website or Report Server Manager website without any issues (i.e., http://my_IP/MyReportServer
If I REMOVE MY_ACCOUNT from the Web Server Administrator group, the web page returns the error:
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed)...
Is there a way to make this work WITHOUT making MY_ACCOUNT an administrator? If you need more information, please advise. Thank you!