Windows NTLM Authentication & Administrators Group

Last Post 21 Oct 2008 01:06 PM by u2khanh. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
u2khanh
New Member
New Member

--
21 Oct 2008 09:58 AM
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 or http://my_IP/MyReportManager

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!
u2khanh
New Member
New Member

--
21 Oct 2008 12:36 PM
Hi RM!

Thanks for the reply. If I'm thinking what you're thinking... YES, I added the user MY_ACCOUNT as a CONTENT MANAGER (as well as \Domain Users, SERVERNAME$).
u2khanh
New Member
New Member

--
21 Oct 2008 01:06 PM
BTW:
I've also added ALL the other roles (Browser, publisher, etc)

The Web Server Windows Event logger shows:
Type: Failure Aud
Category: Logon/Logoff
Event ID: 534
User: NT Authority/System

Logon Failure:
Reason: The user has not been granted the requested
logon type at this machine
User Name: $DevPassport_Itest
Domain: CA
Logon Type: 2
Logon Process: Advapi
Authentication Package: Negotiate
Workstation Name: PPTSDSW2K3S9
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY


Acceptable Use Policy
---