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 […]