1802 upgrade stuck at replication

[amit paul]

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

Edited August 20, 2018 by amit paul
cmupdate file attached.

[anyweb]

please attach your cmupdate.log....

[amit paul]

file attached.

CMUpdate (2).txt

[anyweb]

from the log there are several reports of SQL access issues, double check your permissions before trying again.

 

*** [42000][4060][Microsoft]

[SQL Server]Cannot open database "CM_MDC" requested by the login. The login failed.

[amit paul]

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.

 

 

[anyweb]

this is the most recent failure. System cannot connect to SQL, start troubleshooting it - https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

 

[amit paul]

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

[amit paul]

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

[anyweb]

does NT Authority\System have dbo connect permission in SQL ?

[amit paul]

attached NT\Auth permission screenshot