What to fill in the server name of sqlserver2017

SQL Server 2017 The server name is a unique identifier that identifies the database server. The filling steps are as follows: Open SQL Server Configuration Manager, find and select the server instance to be modified, fill in the name in the "Server Name" field, in the format of FQDN or IP address. Save and apply changes.

How to fill in the server name of SQL Server 2017

The server name of SQL Server 2017 is used to identify it on the network and a unique identifier to access the database server. The following are the steps to fill in the server name:

1. Open SQL Server Configuration Manager

• Enter the "Start" menu and find "SQL Server Configuration Manager ".
• Double-click to open the tool.

2. Locate and select the server instance you want to modify

• In the left pane, expand SQL Server Network Configuration.
• Expand "Protocol".
• Select the TCP/IP protocol to modify (such as "TCP/IP").
• In the right pane, double-click the "TCP/IP Properties" option.

3. Fill in the name in the "Server Name" field

• In the "General" tab, find the "Server Name" field.

• Enter the name of the server. The name must be in the following format:

  • Fully Qualified Domain Name (FQDN): For example, server.domain.com
  • IP address : For example, 192.168.0.1

4. Click OK to save changes

• Click OK to apply the changes and close the TCP/IP Properties dialog box.
• Click "OK" to close "SQL Server Configuration Manager".

Note:

• The server name is case-sensitive.
• The server name must be unique and cannot duplicate any other server name on the network.
• If the server name is changed, the SQL Server service will need to be restarted to apply the changes.

The above is the detailed content of What to fill in the server name of sqlserver2017. For more information, please follow other related articles on the PHP Chinese website!