Server SetupSQL Server 2022 SetupSQL Server 2022 Setup Open Setup.exe In the Planning tab on the left navigation panel in the setup Click System Configuration Checker Go to the Installation tab on the left navigation panel in the setup Click New SQL Server standalone installation Click Next, keeping all default entries Accept the license terms Click Next Check Use Microsoft Update to check for updates (recommended). Windows Firewall section may show a warning, but it's okay. We can proceed. Click Next Select everything except PolyBase Query Service for External Data Click Next Instance name: AC_LOCAL_DB_SRVR/AC_DEV_DB_SRVR/AC_QA_DB_SRVR/AC_PROD_DB_SRVR (DB Server Name) Make SQL Server Agent Startup Type Automatic Check Grant Perform Volume Maintenance Tasks privilege Click Next Select Mixed Mode Authentication Username: sa (will be selected by default) Password: 26manoj@Sql12 Click Add Current User as the SQL Server administrator Click Next Click Add Current User as the SQL Server Analysis Services administrator Click Next Keep Integration Services default entries and click Next Keep clicking Next and Click Install Once the installation is complete, restart the machine (Best Practice) Check all SQL Server Services Avoid Delayed Start from all services if it is set so Go to SQL Server Configuration Manager Open SQL Server internal port in WINDOWS firewall advanced setup Inbound rule - (both TCP & UDP). The default port is 1433 Go to SQL Server Configuration Manager → SQL Server Network Configuration → Protocols for [Database Server Name] → TCP/IP Select Enabled to Yes Go to IP Addresses → Add the port number (1433) in the TCP Port field in the IP ALL section (at the very bottom) Click Apply Click OK Go to SQL Server Services and restart SQL Server (Your Server Name) Test accessing SQL Server from SSMS from another machine using server IP and the sa credentials