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 IP Address are automatically detected.
Setup AlwaysOn 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 AlwaysOn feature is enabled for the SQL Server. Steps Windows Failover Cluster Manager Create new cluster... » 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 Join Computer to a Cluster in Failover Cluster Manager
Error: When trying to create a new cluster in Failover Cluster Manager, trying to add a new server gives the following error… The computer "xxxxx" is joined to a cluster. The computer is cloning from an existing computer that was part of a cluster. Fix: Open up PowerShell (as administrator) on that computer and 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.
Unable to start SQL Server Service
Problem: Unable to start SQL Server Service. Check Windows Logs in “Event Viewer”. Cause: FCB::Open failed: Could not open file C:\MSSQL\tempdb.mdf for file number 1. OS error: 3(The system cannot find the path specified.). Problem with tempdb. Unable to find tempdb drive.
Reconfigure SQL Server Reporting Services After Server Name Change
Error 1: The service is not available. Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details. Error 2: The report server isn’t configured properly. Contact your system... » read more