0

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 am facing error.

No Features Selected for Upgrade

Discovery Report is :

Discovery Report for Microsoft SQL Server 2016 SetupMicrosoft SQL Server 2016 Setup Discovery Report

ProductInstanceInstance IDFeatureLanguageLanguageVersionClusteredConfiguredMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSSQL13.MSSQLSERVERDatabase Engine Services1033Standard Edition13.1.4001.0NoYesMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSSQL13.MSSQLSERVERSQL Server Replication1033Standard Edition13.1.4001.0NoYesMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSSQL13.MSSQLSERVERFull-Text and Semantic Extractions for Search1033Standard Edition13.1.4001.0NoYesMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSSQL13.MSSQLSERVERData Quality Services1033Standard Edition13.0.1601.5NoYesMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSAS13.MSSQLSERVERAnalysis Services1033Standard Edition13.1.4001.0NoYesMicrosoft SQL Server 2016MSSQLSERVER.INACTIVEMSRS13.MSSQLSERVERReporting Services - Native103313.1.4001.0NoYesMicrosoft SQL Server 2016Client Tools Connectivity1033Enterprise Edition13.0.14500.10NoYesMicrosoft SQL Server 2016Client Tools Backwards Compatibility1033Enterprise Edition13.0.14500.10NoYesMicrosoft SQL Server 2016Client Tools SDK1033Enterprise Edition13.0.14500.10NoYesMicrosoft SQL Server 2016Data Quality Client1033Enterprise Edition13.0.1601.5NoYesMicrosoft SQL Server 2016Integration Services1033Enterprise Edition13.1.4001.0NoYesMicrosoft SQL Server 2016Reporting Services - SharePoint13.1.4001.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSSQL11.MSSQLSERVERDatabase Engine Services1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSSQL11.MSSQLSERVERSQL Server Replication1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSSQL11.MSSQLSERVERFull-Text and Semantic Extractions for Search1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSSQL11.MSSQLSERVERData Quality Services1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSAS11.MSSQLSERVERAnalysis Services1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012MSSQLSERVERMSRS11.MSSQLSERVERReporting Services - Native1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012SSMS1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Adv_SSMS1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Client Tools Connectivity1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Client Tools Backwards Compatibility1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Client Tools SDK1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Data Quality Client103311.3.6020.0NoYesMicrosoft SQL Server 2012BIDS1033Standard Edition11.3.6020.0NoYesMicrosoft SQL Server 2012Integration Services1033Standard Edition11.3.6020.0NoYes

Thanks!!!!!

  • What is the instance's default backup location? Check the Database Settings tab on the server's properties in SSMS. – Bacon Bits Dec 9 '17 at 9:41
  • Did you check the version of SQL Engine and positive that upgrade did not happen during first try? – SqlWorldWide Dec 10 '17 at 2:30
  • Could you share the report after running this on command line: setup.exe /Action=RunDiscovery You could also include setup logs: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\xxxx – Asteway Dec 10 '17 at 9:43
  • Yes @SqlWorldWide I used SELECT @@VERSION and found it's 2012 Standard Edition. – Rajesh Ranjan Dec 10 '17 at 9:45
  • Default backup path was configured to Q: – Rajesh Ranjan Dec 10 '17 at 9:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.