How to direct two or more ALM servers to connect to one SQL server?

  • KM00821985
  • 31-Mar-2014
  • 31-Mar-2014

Summary

The document shows the approach the direct two or more ALM servers to connect to one SQL server.

Question

The document shows the method the direct two or more ALM servers to connect to one SQL server.

Answer

Here is the approach

1. Change SQL authentication to Mix Mode
    a) SQL Server management studio ->  left column -> right click on the server (top line) -> Properties -> Security
    b) Select "SQL Server and Windows Authentication mode"

2. Set Network
     a) On Firewall settings, open 1433 port
     b) To enable Ping cmd, open Firewall configuration -> Inbound Policy  -> File and Printer Sharing (Echo Request - ICMPv4-In)