Scripts to open Windows Firewall Ports for SQL Server

I was looking for a PowerShell replacement of the script provided in MS KB “How to open the firewall port for SQL Server on Windows Server 2008” which uses the netsh command to open the Windows firewall ports for SQL Server. Because in future versions of Windows, Microsoft might remove the Netsh functionality for Windows Firewall with Advanced Security. Microsoft also recommends that you transition to Windows PowerShell if you currently use netsh to configure and manage Windows Firewall with Advanced Security. And I found the answer it on the TechNet Forums.¬†For reference I have posted the…

Read More

MSSQL Server not starting after fresh installation

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…

Read More

Upgrade from SQL Server 2014 Express to Standard Edition

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…

Read More