SOLVED Failed To Connect to Remote Distribution Point Error...

[Tahsin Yusuf Demir]

Hello,

On September 30, we had to move our SCCM server's database to another server. During this process, we get errors on some of our distribution points. However, after the operation, I send packages to these distribution points and I don't have any problems and when I check, these DPs are accessible. When I examine the Distmgr.log, I don't see any errors. I checked the network access and ports in various ways, there is no drop. These DPs are connected to another DP as pull dp. The DPs that gave the error sent a status message on the same day and at the same time. I need to reset this somehow and turn all DPs green.

There is a sql command that I use to delete warnings on DPs, and it works very well for me. I don't know if I can find a similar command that I can delete with errors.

I am sharing the sql query that deletes warnings in case it is needed.

delete from dbo.DistributionStatus where LastStatusMsgID = '2388'
delete from dbo.DistributionStatus where InsStr2 = '3010'
exec spRebuildContentDistribution 1

 

[Garth]

It is unsupported to delete anything from the ConfigMgr database without contacting MS support. This could cause more problems that it solves.

 

[Tahsin Yusuf Demir]

It is unsupported to delete anything from the ConfigMgr database without contacting MS support. This could cause more problems that it solves.

I don't want to delete anything. I just want to find out how to fix the problem.

 

[Harshit Pandey]

I don't want to delete anything. I just want to find out how to fix the problem.

But you said you are deleting the warnings with that command?

 

[Garth]

I don't want to delete anything. I just want to find out how to fix the problem.

You posted sql queries to delete stuff from the ConfigMgr database. So did you run them?

 

[Tahsin Yusuf Demir]

You posted sql queries to delete stuff from the ConfigMgr database. So did you run them?

I ran it myself. It does not delete the items in the database, but the warnings for a more detailed troubleshooting process. However, my purpose in publishing this post is to find a solution to my problem, I guess I could not explain it.

 

[Garth]

I ran it myself. It does not delete the items in the database, but the warnings for a more detailed troubleshooting process. However, my purpose in publishing this post is to find a solution to my problem, I guess I could not explain it.View attachment 6586

So the sql query that you posted will clear delete stuff from the database. You don't reset status by deleting things from the database.

When you deployed a package to those DP, in the logs are you seeing them get distributed? Is SQL healthy? Are you sure it is healthy, e.g. what have you done to confirm that ConfigMgr and SQL are working together correctly?

 

[Prajwal Desai]

I ran it myself. It does not delete the items in the database, but the warnings for a more detailed troubleshooting process. However, my purpose in publishing this post is to find a solution to my problem, I guess I could not explain it.View attachment 6586

Thanks for the screenshot, I understand what you're trying to do. Now, why do you want to delete those errors or warnings?. Those are the indicators that tell you what went wrong during the distribution point setup. When you install a DP role on a server, you may see some warnings or errors initially, but they should turn green after the DP role installation is complete. If they are still there, it means the selected DP still has errors.

 

[Tahsin Yusuf Demir]

Thanks for the screenshot, I understand what you're trying to do. Now, why do you want to delete those errors or warnings?. Those are the indicators that tell you what went wrong during the distribution point setup. When you install a DP role on a server, you may see some warnings or errors initially, but they should turn green after the DP role installation is complete. If they are still there, it means the selected DP still has errors.

Hi,

The problem is solved, on Saturday the DP Content Validation process was done in time and the DPs with this problem were fixed. All green. Thank you.