Configuring a Windows Database Server to have a Static IP Address

It is common to configure server machines to have a static IP. This avoids having to rely on DNS resolution to find the server when its IP address changes, and it also allows you to associate the hostname to the server's static IP address on the machine to skip DNS resolution altogether, increasing network performance.

If your machine is currently connected to a DHCP server that dynamically assigns IP addresses, you can configure your machine to permanently use its current IP address. To do this, you can start by making note of the information for your current network connection, then using these parameters for a permanent IP address.

How to obtain the information about your current connection

1. Open Command Prompt and enter the following command:.

   > ipconfig /all

   This will output information about your current connection:

   Windows IP Configuration Host Name . . . . .  . . . : <hostname>

2. Primary Dns Suffix . . . . . . . . . . . . . . .  . : <domain name>

3. Node Type . . . . . . . . . . . . . . . . . . . . . : Peer-Peer

4. IP Routing Enabled. . . . . . . . . . . . . . . . . : No

5. WINS Proxy Enabled. . . . . . . . . . . . . . . . . : No

6. DNS Suffix Search List. . . . . . . . . . . . . . . : <domaine names>

7. Ethernet adapter Ethernet:

8. Connection-specific DNS Suffix . . . . . . . . . .  : <domain name> Description . . . . . . . . . . . . . . . . . . . . : <adapter name>

9. Physical Address. . . . . . . . . . . . . . . . . . : <MAC address>

10. DHCP Enabled. . . . . . . . . . . . . . . . . . . . : Yes

11. Autoconfiguration Enabled . . . . . . . . . . . . . : Yes

12. Link-local IPv6 Address . . . . . . . . . . . . . . : <IPv6 address>

13. IPv4 Address. . . . . . . . . . . . . . . . . . . . : <IPv4 address>

14. Subnet Mask . . . . . . . . . . . . . . . . . . . . : <subnet mask>

15. Lease Obtained. . . . . . . . . . . . . . . . . . . : <date of lease>

16. Lease Expires . . . . . . . . . . . . . . . . . . . : <date of expiration>

17. Default Gateway . . . . . . . . . . . . . . . . . . : <default gateway>

18. DHCP Server . . . . . . . . . . . . . . . . . . . . : <DHCP server address>

19. DHCPv6 IAID . . . . . . . . . . . . . . . . . . . . : <DHCPv6 IAID>

20. DHCPv6 Client DUID. . . . . . . . . . . . . . . . . : <DHCPv6 Client DUID>

21. DNS Servers . . . . . . . . . . . . . . . . . . . . : <DNS server addresses>

22. Primary WINS Server . . . . . . . . . . . . . . . . : <WINS server address>

23. NetBIOS over Tcpip. . . . . . . . . . . . . . . . . : Enabled

25. 1. In the output, under Ethernet adapter Ethernet, make note of the following data:
       • The domains in the DNS Suffix Search List
       • The IPv4 Address
       • The Subnet Mask
       • The Default Gateway address
       • The addresses for the DNS Servers

    How to configure a Windows server to use a static IP

    1. Open the Windows Control Panel:
       • On Windows 7: Open the Start menu and select All Programs > Accessories > System Tools > Control Panel.
       • On Windows 8.1 or Windows 10: Open the Start menu and, in the programs list, select Windows System > Control Panel.
    1. Click View network status and tasks.
    1. On the top-left corner of the Network and Sharing Center, select Change adapter settings.
    1. Right-click on the network adapter used by your machine to connect to your local network, then select Properties.
    2. The Local Area Connection Properties dialog appears.
    1. In the items list, select Internet Protocol Version 4 (TCP/IPv4)
    1. Click on the Properties button under the list.
    2. The Internet Protocol Version 4 (TCP/IPv4) Properties dialog box opens.
    3. Select the Use the following IP address option.
    4. In the IP Address field, enter the IPv4 Address you obtained in earlier.
    5. In the Subnet mask field, enter the Subnet mask you obtained earlier.
    6. In the Default gateway field, enter the Default gateway address you obtained earlier.
    1. Select the Use the following DNS server addresses option.
    1. In the Preferred DNS server field, enter the DNS Servers address obtained earlier.
    2. If a second DNS server was listed by ipconfig, type it in the Alternate DNS server field. Otherwise, leave this field empty.
    1. Click on Advanced.
    2. The Advanced TCP/IP Settings dialog opens.
    1. Select the DNS tab.
    1. Select the Append these DNS suffixes (in order): option.
    2. For each DNS Suffix obtained earlier, click on Add, then type in the suffix. Add the suffixes in the order in which there were listed.
    3. Click on OK.
    4. Click on OK in the Internet Protocol Version 4 (TCP/IPv4) Properties dialog.
    5. Click on OK in the Ethernet Properties dialog.