-
Load IE and
in the “Address:”
bar type “http://<MP_name>/sms_mp/.sms_aut?mplist”
which will return a blank screen if the MP is working.
-
Run “http://<MP_name>/sms_mp/.sms_aut?mpcert”
which will return a long string of numbers if the MP is working.
-
Run the “MPTroubleshooter”
tool in the SMS 2003 Toolkit 2.
-
Verify IIS
and BITS are installed.
-
Verify the “Distributed
Transaction Coordinator”
service is “Enabled”
and started.
-
Verify the “COM+
System Application”
service is “Enabled”
and started.
-
Verify the “Task
Scheduler”
service is “Enabled”
and started.
-
Verify the “Windows
Management Instrumentation”
service (not the “Windows
Management Instrumentation Driver Extensions”
service) is “Enabled”
and started.
-
Verify the “SMS
Agent Host”
service is “Enabled”
and started.
-
Verify the “World
Wide Web Publishing Service”
is “Enabled”
and started.
-
Verify that
the Default Web Site is running on Port 80 (unless you’ve explicitly changed
it for a reason).
-
Verify that
the Computer account of the machine the MP is running on has been added to
the “SMS_SiteSystemToSQLConnection_<site_code>”
group (if the MP is on a Secondary this group exists on the Parent Primary).
-
Verify that
the Computer account of the machine the MP is running on has been added to
the “SMS_SiteSystemToSiteServerConnection_<site_code>”
group (if the MP is on a Secondary this group exists on the Parent Primary).
-
Verify that
both “TCP/IP”
and “Named
Pipes”
are present in the “Enabled
protocols by order”
column in the “SQL
Server Client Network Utility”
as detailed in the “How
do I create a Proxy MP?”
FAQ.
-
You may need
to update MDAC, the process for which is detailed in Microsoft Knowledge
Base Article
820910
“How to obtain
the latest MDAC 2.7 service pack”.
-
If you are
running SQL using a user account rather than under the System context you
will need to update the Service Principal Name (SPN), in AD as detailed in
Microsoft Knowledge Base Article
829868
“Systems
Management Server 2003 Advanced Security Site with Remote SQL Does Not
Connect to SQL Server”.
-
If the SQL
Server your MP connects to is in a different Domain you may also need to
update the SPN as detailed in the previous step.
-
Make sure you
have applied the relevant SMS-specific template from the SMS Toolkit 2 for
the version of IIS you are using (IIS Lockdown for IIS5 and URLScan for IIS
6).
-
Remove the
MP role from the server.
-
Disable IIS
then uninstall it and reboot the server.
-
Verify the “Distributed
Transaction Coordinator”
service is “Enabled”
and started.
-
Verify the “COM+
System Application”
service is “Enabled”
and started.
-
Verify the “Task
Scheduler”
service is “Enabled”
and started.
-
Verify the “Windows
Management Instrumentation”
service is “Enabled”
and started.
-
Reload IIS
making sure that BITS and WebDAV are installed and allowed as part of
installing IIS.
-
Verify the “World
Wide Web Publishing Service”
is “Enabled”
and started.
-
Verify that
the Default Web Site is running on Port 80 (unless you’ve explicitly changed
it for a reason).
-
Verify that
the Computer account of the machine the MP is running on has been added to
the “SMS_SiteSystemToSQLConnection_<site_code>”
group (if the MP is on a Secondary this group exists on the Parent Primary).
-
Verify that
the Computer account of the machine the MP is running on has been added to
the “SMS_SiteSystemToSiteServerConnection_<site_code>”
group (if the MP is on a Secondary this group exists on the Parent Primary).
-
Reconfigure
the MP Site System role on the SMS Site Server.