amit paul

can any one help me out to solve this issue??

We are facing issue with content distribution on a new DP.

Yes Garth

Unfortunately I tried all troubleshooting however CSS failed to provide any possible solution after two days troubleshooting.

Yes niall, thanks a lot for all your support Thank you Garth for your support.

issue got resolved after solving SQL server configuration manager issues. Open a command prompt as administrator Navigate to your SQL version’s shared directory (cd <version path>): SQL 2008: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\ SQL 2008 R2: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\ SQL 2012: C:\Program Files (x86)\Microsoft SQL Server\110\Shared\ SQL 2014: C:\Program Files (x86)\Microsoft SQL Server\120\Shared\ Then run the following command: mofcomp sqlmgmproviderxpsp2up.mof 1802 Upgrade successfully completed.

Hi Garth, SQL Name pipes are disabled. Do I need to enable it.

CMUpdate.log file attached. You might get some error related to SQL as I have restarted SQL service many a times. CMUpdate (2).txt

ried to open SQL Server Configuration Manager however its not allowing me to open, so I was not able to check the SQL name Pipes. screen shot already shared.

Niall & Garth, any suggestion here???

Hi Found Windows Update service was stopped, after restarting that got some movement however with new error

Niall & Garth, I have opened a ticket with MS however no luck yet.

Tried to open SQL Server Configuration Manager however its not allowing me to open, also tried restarting SQL service and SMS_EXECUTIVE service still no luck, Kindly suggest do I need to contact MS?

not getting any error related to SQL connection as of now. Sql is installed on same box where Primary server is installed. @GarthMJ AUTHORITY\SYSTEM is marked as Sysadmin

attached NT\Auth permission screenshot

I checked with my sql team and every thing is in place, i re-entered password for MSSQLSERVER service and restarted, no progress yet

Ok, Let me check with SQL team and I will let you know

I already went through with this log file with sql error however this is an older status and If I can see now, not getting any error related to sql. my service account has sysadmin and public role enabled, kindly suggest what else I can check.

file attached. CMUpdate (2).txt

Hi Niall, I am facing issue while upgrading 1802 from 1706. It is not moving forward from update content library stage. I tried all possible troubleshooting. SQL rights are correct, I tried removing the GUID and downloaded again. I already removed update using CMUpdateReset.exe multiple times, Under CMUpdate.log its showing "There are no pending update package to be processed". please help CMUpdate (2).txt