SQL Server Alias won't work for my database instance
The problem was that the 'SQL Server Browser' service was not running.

I right-clicked this, clicked 'Properties', set the start mode to 'Automatic' then manually selected to start the service.