Distribution Point Configuration Status - SMS Client - Restart might required
Annoying message that doesn't go away even after a restart.
To remove it:
1. Make sure you have good backup of the site DB
2. Run the following select statement to find the Distribution Points in this state: select * from dbo.DistributionStatus where InsStr2 = '3010'
3. Once identified then Delete a record an affected DP with: delete from dbo.DistributionStatus where ID = <DPID of affected DP identified by above command>
Source:
