I know MSSQL can have various login modes, windows only, windows + sql, etc. named pipes, tcp/ip.
Really I'm not sure what we should use. We have two servers each with IIS + MSSQL, network load balancing for IIS and DB mirroring for MSSQL.
Want to secure it so only the two servers can access MSSQL on each server (and obviously so the mirroring works).
Currently just the one server is in production and I think TCP/IP/named pipes is on, windows + sql authentication but using the firewall, blocked access to the TCP port.
What's the best way of setting this up?