What is the server name of sqlserver2019

The default format of the server name is: \<Computer Name>\<Instance Name>. Methods to find the server name include: SQL Server Management Studio, SQL Server Configuration Manager, T-SQL query. The steps to change the server name are: stop the SQL Server service, run the sqlservr.exe -g command, and restart the SQL Server service.

SQL Server 2019 Server Name

SQL Server 2019 Server Name By default is:

\<Computer Name>\<Instance Name>

Where:

• <Computer Name> Is the name of the computer where SQL Server is installed.
• <Instance Name> is the name of the SQL Server instance.

Find the server name

There are several ways to find the SQL Server 2019 server name:

• ##SQL Server Management Studio (SSMS): After connecting to the server, the server name is displayed in the SSMS title bar.
• SQL Server Configuration Manager: Under "SQL Server Network Configuration", select "Protocols for <Instance Name>" and then view the "Server Name" column.
• T-SQL Query: Use the following query to find the server name from the sys.servers system table:

<code>SELECT name FROM sys.servers WHERE is_current_server = 1;</code>

Change the server name

To change the SQL Server 2019 server name:

Stop the SQL Server service in "Windows Services".
1. Run the following command:

2. <code>sqlservr.exe -g <新服务器名称></code>

Restart the SQL Server service.

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