Breaking News: Grepper is joining You.com. Read the official announcement!

how to change server name in sql server

Maaz answered on July 3, 2022 Popularity 9/10 Helpfulness 3/10

answer how to change server name in sql server

how to change server name in sql server

Comment

-- How to change server name in sql server (complete guide)?
-- It's only for PCs not having Windows Server installed.

-- Steps:
-- 1. Execute below to drop the current server name

	EXEC sp_DROPSERVER 'old_server_name'
    
-- 2. Execute below to add a new server name. Make sure local is specified.

	EXEC sp_ADDSERVER 'new_server_name', 'local'
    
-- /* Hey! it's making, two server names locally. Totally shocked...!!! */

-- 3. Restart SQL Services from ***SQL Server 2016 Configuration Manager***.

-- 4. Verify the new name using:

	SELECT @@SERVERNAME
	SELECT * FROM sys.servers WHERE server_id = 0
    
-- I must point out that you should not perform rename if you are using:

	-- 1. SQL Server is clustered.
	-- 2. Using replication.
	-- 3. Reporting Service is installed.

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: server-name sql sql-server

Link to this answer
Share Copy Link

Contributed on Jul 03 2022

Maaz

0 Answers Avg Quality 2/10

how to change server name in sql server

Contents

More Related Answers

how to change server name in sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.