Security Hardening or Security Audits in an enterprise are some of the motivation for DBAs to run SQL Server default instance on a non-default port. For standalone instances, there are no challenges in changing the default instance port to non-default port, however for clustered instance there are some considerations since cluster.exe performs IsAlive check by… Continue reading Consideration for changing the default port of default SQL instance on Multi-subnet Failover Cluster
As SQL 2012 is in it’s RC0 phase, I was trying to configure AlwaysON on my 2-node WSFC with node and disk majority.Next I installed Default instance of SQL Server in parallel ( to save some time ) on both nodes of the WSFC.Next I enabled my instances for AlwaysON from SQL Configuration Manager for… Continue reading Failed to join the instance to the availability group while configuring AlwaysON
The ACT7 software installs sql server 2005 express edition along with the installation of ACT7 software. When we try to apply the latest security patch 948109 released by Microsoft for sql server 2005, the installation may fail. In order to find the cause of the installation we need to look into the setup boothstrap logs… Continue reading UNABLE TO INSTALL SECURITY PATCH 948109 TO SQL SERVER 2005 EXPRESS EDITION WHICH IS INSTALLED ALONG WITH ACT7 SOFTWARE.