Simple Troubleshooting Management Points

 

Just below point when ever you stuck with MP issues

1) Run http://<MP name>/sms_mp/.sms_aut?mplist
This returns a blank screen.
2) Run
http://<MP name>/sms_mp/.sms_aut?mpcert
This returns a long list of numbers and letters.
3) Verify that the DTS Service is enabled.
4) Verify that the Task Scheduler is enabled.
5) Verify that the Windows Management Instrumentation service is running.
6) Verify that the SMS Agent Host service is running.
7) Verify that the World Wide Web Publishing Service is running.
8) Verify that the MP machine account has been added to the
SMS_SiteSystemToSQLConnection_<site_code> group.
9) Verify that the SQL Server has named pipes enabled.
10) Update MDAC on the server.
Review Q820910 for details.
http://support.microsoft.com/default.aspx?scid=kb;en-us;820910
11) SQL boxes that are running under a user account, instead of system,
need the SPN updated in AD.
Review Q829868 for additional details.
http://support.microsoft.com/default.aspx?scid=kb;en-us;829868
12) Crossing domain boundaries between MP and SQL may also need the SPN
updated in AD.
Review Q829868 for additional details.
http://support.microsoft.com/default.aspx?scid=kb;en-us;829868
13) IIS Lockdown Tool
If you are using the IIS lockdown tool on your IIS 5 servers be sure to
apply the SMS server template from the SMS 2003 toolkit.
http://www.microsoft.com/smserver/downloads/2003/tools/toolkit.asp
14) Deinstall the MP and IIS, then reinstall IIS and the MP.
a) Remove the MP role on the server.
b) Disable IIS. Remove completely. Reboot the server.
c) Verify that the DTS Service is enabled.
d) Verify that the Task Scheduler is enabled.
e) Verify that the Windows Management Instrumentation service is
running.
f) Enable BITS, enable WEBDEV and install IIS.
g) Verify that the World Wide Web Publishing Service is running.
h) Verify that the MP machine account has been added to the
SMS_SiteSystemToSQLConnection_<site_code> group.
i) Enable MP role on the server.

-------------------
Thanks,
http://paddymaddy.blogspot.com/

2 comments:

soumya said...

Thanks for sharing valuable infomration on microsoft content please share more content MSBI Online Training Hyderabad

Anonymous said...

The Corner Ring Bound Book is also recommended. http://rnoav36ai7.dip.jp http://t6oe8vxa50.dip.jp http://vjhkxu52d3.dip.jp

Post a Comment