SQL Server Configuration Requirements

  1. Open the SQL Server Configuration Manager.
  2. Click SQL Server Configuration Manager to open it.
  3. In the Protocols for MSSQLSERVER, right-click on TCP/IP; click Enable.
  4. Right-click again on TCP/IP, click Properties.
  5. In the IP Addresses Tab, verify that the ports are configured.
    Note: The default port for SQL Server is 1433.
  6. Open the Microsoft SQL Server Management Studio.
  7. Right click on the server. Click Properties.
  8. Click Connections. Verify that Allows remote connections to this server is checked. Click OK.
WKFS