Configuration Wizard Error | Unable to Load the Web page and Menu Tabs

Question

• Error while executing script- The object '_dta_mv_3' is dependent on column 'Name'.
The object '_dta_mv_5' is dependent on column 'Name'.
The object '_dta_mv_7' is dependent on column 'Name'.
ALTER TABLE ALTER COLUMN Name failed because one or more objects access this column.

Getting this error while running config wizard. All services are up.

Can anyone help on this.

Config Wizard_Error.PNG

tony.johnson · Answer

Can you determine if these objects are views or tables? There is a possibility these are views created by Database Tuning Advisor https://www.sqlservercentral.com/forums/topic/views-that-are-prefixed-with-_dta_mv

Please ensure you have a backup of the database prior to making any changes.

JaroslawLadyga · Answer

I'd suggest to analyze Config Wizard log and possibly stop all services, reboot sql server then start Config Wizard again.