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
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.
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
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
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.
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
Problem: User can not connect to SQL Server from a remote computer via SSMS. Ping returns unreachable. When user remote desktop on to server and use SSMS from the server, the user is able to connect to SQL Server. Note: Make sure SQL Server Instance is running on the server. If multiple instances installed, make... » read more
Displaying the File Extension in Windows Vista and Windows 7 Click the Start menu. … Type “folder options” (without the quotes). … A dialog box with the title “Folder Options” will appear. … Click to uncheck the box for “Hide extensions for known file types”. Click the “OK” button at the bottom of the dialog box.
You can access the Microsoft Failover Cluster Management in a couple of different ways: Go to Server Manager, Features, Failover Cluster Manager Go to Control Panel, Administrative Tools, Failover Cluster Manager Sources: https://www.mssqltips.com/sqlservertip/2672/managing-a-windows-and-sql-server-cluster-using-the-failover-cluster-manager-tool/
Using .iso file. Right click on the file .iso and select the option to Mount, this will create a virtual DVD drive (Usually the E: drive). After the virtual drive has been created (mounted), you can use the drive to access the content.