What is the server name of sqlserver2019

The default format of the server name is: \\. 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:

\\

Where:

• Is the name of the computer where SQL Server is installed.
• 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 " and then view the "Server Name" column.
• T-SQL Query:Use the following query to find the server name from thesys.serverssystem table:

SELECT name FROM sys.servers WHERE is_current_server = 1;

Change the server name

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

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

   Copy after login

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!