I’m wondering if I should try to uninstall and reinstall SQL 2016.
As a last resort to check out, maybe the installer "
Microsoft SQL Server 2016 Setup (English)" provides a repair option.
Otherwise I don't see any other option as to uninstall and reinstall.
These installed programs are related to SQL 2016 so make sure they are uninstalled too before reinstalling:
- GDR 4224 for SQL Server 2016 (KB4458842)
- Service Pack 1 for SQL Server 2016 (KB3182545) (64-bit)
- Microsoft SQL Server 2016 (64-bit)
- Microsoft SQL Server 2016 RsFx Driver
- Microsoft SQL Server 2016 Setup (English) <- this is probably the main installer package
- Microsoft SQL Server 2016 T-SQL Language Service
- Microsoft SQL Server 2016 T-SQL ScriptDom
- Browser for SQL Server 2016
- Microsoft VSS Writer for SQL Server 2016
- SQL Server 2016 Batch Parser
- SQL Server 2016 Common Files
- SQL Server 2016 Connection Info
- SQL Server 2016 Database Engine Services
- SQL Server 2016 Database Engine Shared
- SQL Server 2016 DMF
- SQL Server 2016 Shared Management Objects
- SQL Server 2016 Shared Management Objects Extensions
- SQL Server 2016 SQL Diagnostics
- SQL Server 2016 XEvent