Change the SQL Server Service Account Open the SQL Server configuration manager. We need to change the service account for SQL server services. Right click on SQL server service, select properties, go to log on tab, click on Browse button, click on location select Entire Directory and click on ok, now type the name Administrator […]
Installation of SQL Server on Node 1 1. To install the SQL server mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server stand-alone installation. 2. In this screen enter the product key (if you have purchased then key filled automatic) […]
Prerequisite for SQL Server Always On Setup All Nodes are in Domain Network Static IP should be assigned on all nodes Windows Failover Cluster Roles should be installed on all nodes SQL Server of same version should be installed on all nodes All Ports should be allowed in Windows firewall SQL Server services should be […]
SFTP (Secure File Transfer Protocol) is a network protocol that uses the Secure Shell (SSH) protocol to securely transfer files between computers. How it works SSH creates a secure connection when logging into a remote computer. SFTP uses SSH to securely transfer files between a client and a remote host server. SFTP authenticates the client […]
Support for Windows 10 will end in October 2025 After 14 October 2025, Microsoft will no longer provide free software updates from Windows Update, technical assistance, or security fixes for Windows 10. Your PC will still work, but we recommend moving to Windows 11. What is Windows 10 end of life? ANS: End of life […]
ASP.NET is an open source web framework, created by Microsoft, for building modern web apps and services with .NET. ASP.NET is cross platform and runs on Windows, Linux, macOS, and Docker Download .NET Framework Install the latest version of dotnet from below link as per your application compatibility. https://dotnet.microsoft.com/en-us/download/dotnet/ Note: Before installing the dotnet latest […]
Microsoft releases the patches for Windows Server 2016 every month to updates the servers. From here you can download and install the latest patches on server. 2024-06 Cumulative Update for Windows Server 2016 for x64-based Systems (KB5039214) https://www.catalog.update.microsoft.com/Search.aspx?q=KB5039214%20 2024-07 Cumulative Update for Windows Server 2016 for x64-based Systems (KB5040434) https://www.catalog.update.microsoft.com/Search.aspx?q=KB5040434 2024-08 Cumulative Update for Windows […]
Microsoft releases the patches to updates the windows server every month. From here you can download and install the latest patches on servers. 2024-07 Cumulative Update for Windows Server 2019 for x64-based Systems (KB5040430) https://www.catalog.update.microsoft.com/Search.aspx?q=KB5040430 2024-07 Cumulative Update for .NET Framework 3.5, 4.7.2 and 4.8 for Windows Server 2019 for x64 (KB5041017) https://www.catalog.update.microsoft.com/Search.aspx?q=KB5041017 2024-08 Cumulative […]
Note: Please take backup of window Registry before doing change process of registry. Go to run command type regedit, Registry will open, Select the SCHANNEL,( by going this location- HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL) Go to file and export the Registry backup in other disk for safe purpose. Also check the compatibility of your application, it might be possible […]
Installation of SQL Server Failover Cluster on Node 1 Step 1: To install the SQL server on mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server fail-over cluster installation. Step 2: In this screen enter the product key (if you […]