How to fill in the server name in sqlserver2019

SQL Server 2019 Server name filling method

Server name rules

• The server name must comply with the following rules:

  • Starts with a letter or underscore
  • Contains only letters, numbers and underscores
  • No more than 15 characters
  • Cannot contain spaces or other special characters The characters
  • cannot start or end with "."

Fill in the steps

1. Log in to SQL Server Management Studio (SSMS)
2. Right-click "Server Object"
3. Select "Connect"

4. Enter the server name in the "Server Name" field

   • If it is a local server, enter ".\SQLEXPRESS"
   • If it is Remote server, enter the IP address or host name of the server, such as "192.168.1.100" or "my-server.domain.com"
5. Click "Connect"

Example

• Local server: ".\SQLEXPRESS"

• Remote server:

  • IP address: "192.168.1.100"
  • Host name: "my-server.domain.com"

Tip

• If you are not sure about the server name, check the server documentation or ask your system administrator.
• If you are having trouble connecting, make sure you have TCP/IP connections enabled and the appropriate ports open in your firewall.

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