After the installation of Microsoft SQL Server 2014 Express I encountered a problem that the services could not be started. It seems that the installation have set the paths to the model, MSDB and tempdev to the wrong location. After uninstall the SQL Server instance and reinstalling it, the problem persists. No settings are altered in the setup properties, also I could not reproduce this same error on another server even using the same deployment image for the Azure VM. The solution is to change the paths to those 3 databases to the right location with starting the instance in…
All posts in Server
This article will describe the steps to upgrade a SQL Server 2014 Express to Standard. Since the release of 2008 R2 it is quite simplified to do this kind of edition upgrades and it is almost the same for every version after 2008 R2. Before that version, you needed to start the setup with “SKUUPGRADE=1”, the command in older versions is: setup.exe SKUUPGRADE=1 Here I’ll show the steps to perform an edition upgrade from SQL Server 2014 Express to Standard. First start the SQL Server 2014 installer, click on the maintenance tab and…