I was able to resolve the issue I was having.
Background:
1 Central Site Server with SQL located on-the-box
1 Reporting point server with IIS installed
Added reporting point role to reporting point server.
Open http:\\server\smsreporting_sitecode
Received error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
on Database server, application log shows error for "FAILURE AUDIT" - Event ID 18456 - Description: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: <rp server IP address>]
Solution:
Create a service account.
On the Database server, Grant the service account a login to the site database
Give it the "Public" "server role"
Go to User Mapping, select the check box next to your SMS database and assign the "Database Role membership for: SMS_SiteCode" to Public AND smsdbrole_RP.
On the reporting point server, open Start > Run and type in services.msc
Right-click on the service "SMS_REPORTING_POINT".
Click on the log on tab and change the logon to use your newly created service account.
Restart SMS_REPORTING_POINT Service
This resolved the issues I had with the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Hope someone may find this useful.
-Nick-
Nicholas Aquino
Ann Arbor, Michigan
>>> On 6/25/2009 at 4:29 PM, in message <1077806031_439997330888@PE3-4-myitforum.orcsweb.com>, "Steve Thompson" <sthompson@myitforum.com> wrote:
And, failing that, check that your SQL Server has properly registered SPN's in AD.
Steve
From: "Jim Bezdan" <jbezdan@sycomtech.com>
Sent: Thursday, June 25, 2009 1:23 PM
To: "mssms@lists.myitforum.com" <mssms@lists.myitforum.com>
Subject: RE: [mssms] Remote reporting point issue
Is the remote reporting point server's computer account in the SMS_SiteServerToSiteSystemConnection_SITECODE group on the primary site server?
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Nick Aquino
Sent: Thursday, June 25, 2009 1:45 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Remote reporting point issue
I've setup a reporting point for SCCM on a separate server.
I have used the default configuration as documented from Microsoft for configuring this reporting point (right-click, install reporting point, make sure it has webdav and asp).
When I go to access the reports for SCCM through the reporting point's website, I receive the following error:
An error occurred when the report was run. The details are as follows:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Error Number:
-2147217843
Source:
Microsoft OLE DB Provider for SQL Server
Native Error:
18456
I look at the central site server, where the SQL database is located and see, in the event viewer, under the application log:
Computer CentralSiteServer
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: <IP Address of reporting point here>]
I haven't been able to determine what, exactly, is going on and where I'm missing security rights. It seems that I may need a service account setup for the reporting point to access SQL, but don't know where to set it up and can't find documentation on this.
SQL is running with a service account.
Any help/guidance would be appreciated.
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
This email is intended only for the above named recipients. The contents of the email and any attached files are confidential. If you have received this email in error you must not copy, forward, disclose the information contained in it, or otherwise use it in any way. Please notify the sender immediately and then delete the message and any attachments.
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
