Preflight Checklist – Installing SQL 2016 Failover Cluster

How to Connect

  1. VPN: [SSL1.upcBroadband.com] (login using UIM account)
  2. [NL CSA P JUMP 001] (login using CSA account)
  3. 172.23.103.219 / 38 (login using CSA ADMIN account)

Nodes

  • Node1 Full Name (rdc ip): LG-W-P-DBS00007.CSA.INTERNAL (172.23.103.219)
  • Node2 Full Name (rdc ip): LG-W-P-DBS00008.CSA.INTERNAL (172.23.103.38)

IP’s

  • Cluster Management (node1 / node2): 172.23.103.219 / 172.23.103.38
  • SQL Server Instance: ??
  • DTC: ??

Drive Allocation

  • D. Media
  • E. Sys & TempDB
  • F. User ID
  • G. Logs
  • H. Backups etc

Collation

  • [SQL Latin1 General CP1 AS]

Windows Checks

  • Power saving NOT enabled
  • Instant File Initialization Enabled (secpol.msc, Local ~, User ~, Perform ~
  • Service Account

 

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s