Hostname Alias for SQL Server Instance

A Hostname alias SQL Server instance is a simple Hostname that allows clients to connect to an instance of SQL Server without specifying an instance name or a port number. They are very useful for upgrades, server migration, consolidation and disaster recovery. A network alias can redirect clients from one server to another. This is …

Continue reading ‘Hostname Alias for SQL Server Instance’ »

SQL Server 2012/R2/2014/2016 Installation Step by Step

In this blog post I will be sharing step by step installation detail for SQL Server with Best Practice for SharePoint. SQL Software requirements 64-bit edition of Microsoft SQL Server 2012 R2 or SQL Server 2014/16 Standard (Enterprise required for Always On) Named SQL alias recommended. Windows Server 2012/R2/2014/16 with latest patch levels should be …

Continue reading ‘SQL Server 2012/R2/2014/2016 Installation Step by Step’ »