Wednesday, June 18, 2008

SMS_REPORTING_POINT

Problem viewing report using IE

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

Also in mpcontrol.log file
“Http verification .sms_aut (port 80) failed with status code 500, Internal Server Error”
End of the file…
Solution

http://support.microsoft.com/?id=832109

Run the command cliconfg on the site server make sure that namedpipe and tcpip are added.
Check all the settings and Restart the IIS server, SMS site component server

You need to run dcomcnfg.exe from the Site server.
Expand:
Computers
My Computer
DCOM Config

Locate the component:
SMS_REPORTING_POINT

Right-Click, select Properties, select Security

Customize and edit:

Launch and Activation Permissions
Configuration Permissions

Add the necessary user's.

No comments: