Install Windows Failover Cluster Manager
Installing Failover Clustering feature using Server Manager The Failover Clustering feature can be installed with either Server Manager or Windows PowerShell cmdlets. In Server Manager, the Add Roles and Features Wizard is used to add roles and\or features. The Add Roles and Features Wizard are accessed in the Server Manager Menu bar by choosing Add Roles... » read more
Account Log On Permission
Log on as a batch job This policy setting determines which accounts can log on by using a batch-queue tool such as the Task Scheduler service. When you use the Add Scheduled Task Wizard to schedule a task to run under a particular user name and password, that user is automatically assigned the Log on... » read more
Always On and SQL Service Account
Account Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Set in “Local Users and Groups”. Account has sysadmin SQL permission on all servers in node. Set in “Local Security Policy”. Account has log on as service policy... » read more
SQL Server Service Account
AlwaysOn Cluster Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Account has sysadmin SQL permission on all servers in node. Account has log on as service policy on all servers in node. Note: Always use SQL Server... » read more
Log on locally
Problem: Unable to remote desktop on to server. Fix: Make sure the service account running the service is added to “Allow log on locally” Local Security Policy -> Local Policies -> User Rights Assignment -> “Allow log on locally”
Adding Listener to Availability Group
Need the following… Host name of Listener, host name need to be setup first in AD Port, default to 1433 Network Mode, use Static IP IP Address, set to specific IP Address Note: For Network Mode, IP Address/Subnet are automatically detected using DHCP option. If you have a specific IP address, use Static IP option.... » read more
Setup Always On High Availability for SQL Sever and Window Failover Cluster
Setting up AlwaysOn High Availability involves setting up… Windows Failover Cluster via Windows Failover Cluster Manager SQL Server vis SQL Server Management Studio Prerequisite Make sure database has a full backup and recovery mode set to Full. Make sure the SQL Server service on each node has the proper permission on the server. (recommend using... » read more
Failed to open the Windows Server Failover Clustering registry subkey ‘HadrAgNameToIdMap’
Error: Failed to open the Windows Server Failover Clustering registry subkey ‘HadrAgNameToIdMap’. (Microsoft SQL Server, Error: 41030) Fix: Disable Always On Available Groups and then Re-enable Always On Available Groups from SQL Server Configuration Manager. Using SQL Server Configuration Manager To disable AlwaysOn Connect to the Windows Server Failover Clustering (WSFC) node that hosts the... » read more
The resource type is not registered in the WSFC cluster.
Error: When trying to create a new Available Group in SQL Server Always On, you get the following error message… Failed to create the Windows Server Failover Clustering (WSFC) resource with the name 'xxxxx' and type 'SQL Server Availability Group'. The resource type is not registered in the WSFC cluster. Fix: Register the resource type... » read more