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

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

Unable to log off RDC

RDCMan Error Unable to log off from xxxxxxxx. Reason: Unable to enumerate remote sessions. Issue: That error is common when using Remote Desktop Connection Manager and trying to log off via right click. You should log out via the start menu in the remote desktop session.

RDS – Log Off vs Disconnect

Remote Desktop Services (RDS or RDP) and Terminal Services provide two options when closing a client session: you can either “Log Off” or “Disconnect“. Log Off – Ends the session running on the remote computer or server. Any applications running within the session will be closed and unsaved changes made to open files will be lost.... » read more

Moving Large Database Backup File

Tips for moving large backup file. Create multiple backup files instead of one large backup file. Use file compression programs like WinZip to compress backup file. Consider trimming the data in the database before creating the backup file. Create database and data from scripts. 7zip You can also use software like 7zip to compress and... » read more