Post reply

How to change Server Name Sql server and Reporting Services.

  • December 17, 2018 at 2:35 pm

    #409387

    I have a Virtaul Server with SQL Server and Reporting Services Installed, how can i change the server name of this server ?

  • December 17, 2018 at 3:12 pm

    #2016600

    Solution

    1. Execute below to drop the current server name

    1EXEC sp_DROPSERVER 'oldservername'

    1. Execute below to add a new server name. Make sure local is specified.

    1EXEC sp_ADDSERVER 'newservername', 'local'

    1. Restart SQL Services.
    2. Verify the new name using:

      1. 1SELECT @@SERVERNAME

      2. 1SELECT * FROM sys.servers WHERE server_id = 0

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply