we have primary servers and 25 secondary servers are reporting to primary. From yesterday we are receiving errors in MPcontrol.log file regarding one of our secondary server and the errors are, [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Failed to get the current CLR Enabled configuration setting for the configured SQL Server hosting the database. Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal And one more important issue is that from Network team we received that Primary is consuming Bandwidth over port 1433 and it is from both side secondary and primary server. Kindly help me!!! Your help will be appreciated.

The HTTP 500 error is likely just a broken MP or a SQL connnection issue. Reinstall the MP and make sure that the site server has correct SQL permissions. The network traffic could be anything. John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

1433 is SQL Server. Depending on your site server layout, this is expected. The primary site makes heavy use of the database as do secondary sites.Jason | http://myitforum.com/myitforumwp/community/members/jasonsandys/ | Twitter @JasonSandys

1433 is SQL Server. Depending on your site server layout, this is expected. The primary site makes heavy use of the database as do secondary sites. Jason | http://myitforum.com/myitforumwp/community/members/jasonsandys/ | Twitter @JasonSandys That would also explain the HTTP 500. If the secondary can't make a connection to SQL it gets and HTTP 500 error. John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

Hi All, Thanks you for your reply, The MP issue is solved as it was due to SQL server was not functionally properly, due to high CPU utilization SQL service went in to hung state and we received MP errors But after we restart SQL, MP started working. But the another issue that we have is, we have 30 secondary servers and apart from all other server only one secondary server is talking to Primary server via port 1433 and taking huge bandwidths and it is vice versa. This causes the high CPU utilization issue to the primary servers so we have stopped all SCCM services for Secondary server. Anybody knows where to check that why and how the Primary and secondary communicating with each other via 1433 and causing huge bandwidth allocation.

I think, you can start with the below blog post from John Nelson http://myitforum.com/myitforumwp/2011/09/19/sccm-guru-webcast-qa-3-troubleshootingconfigmgr-vs-sql/Anoop C Nair - @anoopmannur MY BLOG: http://anoopmannur.wordpress.com User Group: ConfigMgr Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

I think, you can start with the below blog post from John Nelson http://myitforum.com/myitforumwp/2011/09/19/sccm-guru-webcast-qa-3-troubleshootingconfigmgr-vs-sql/Anoop C Nair - @anoopmannur MY BLOG: http://anoopmannur.wordpress.com User Group: ConfigMgr Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

use something like network monitor and match up the dates/time with the windows event log and sccm logs in the ccm\logs directoryMy Microsoft Core Infrastructure & Systems Management blog - blog.danovich.com.au

how to site server has correct permission