After many successful upgrade from SQL Server 2012 to 2016 on production, QA & Dev etc server. I got a problem on a production environment.
I executed setup top upgrade available SQL Server 2012 features to SQL Server 2016.
In the process I got an message that
Setup is not able to create folder/directory in Q:
#its not exec words but meaning was same
Actually Q:\ was backup path configured in Database settings of SQL Server but as we migrated our backups to NAS, Q: drive doesn’t exists anymore & we missed to change configuration.
Some feature like SSRS, SSIS & SSAS etc. upgraded successfully but setup failed to upgrade SQLEngine and it’s dependent.
After changing backup path in database settings of server property. I re-ran the setup but this time I facing error.
No Features Selected for Upgrade
Thanks!