Repair-DbaInstanceName

Want to see the source code for this command? Check out Repair-DbaInstanceName on GitHub.
Want to see the Bill Of Health for this command? Check out Repair-DbaInstanceName.

Synopsis

Updates SQL Server's @@SERVERNAME system variable to match the Windows hostname

Description

Updates SQL Server's @@SERVERNAME system variable to match the current Windows hostname, which is required after renaming a Windows server. This ensures proper functionality for Kerberos authentication and Availability Groups.

The function automatically detects the correct new server name and uses sp_dropserver and sp_addserver to update the SQL Server system tables. It handles common blockers like active replication and database mirroring, optionally removing them with the -AutoFix parameter.

A SQL Server service restart is required to complete the rename process, which the function can perform automatically. The function will skip the operation if the names already match.

https://www.mssqltips.com/sqlservertip/2525/steps-to-change-the-server-name-for-a-sql-server-machine/

Syntax

Repair-DbaInstanceName
    [-SqlInstance] <DbaInstanceParameter[]>
    [[-SqlCredential] <PSCredential>]
    [-AutoFix]
    [-Force]
    [-EnableException]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Repair-DbaInstanceName -SqlInstance sql2014

Checks to see if the server name is updatable and changes the name with a number of prompts.

Example: 2

PS C:\> Repair-DbaInstanceName -SqlInstance sql2014 -AutoFix

Checks to see if the server name is updatable and automatically performs the change. Replication or mirroring will be broken if necessary.

Example: 3

PS C:\> Repair-DbaInstanceName -SqlInstance sql2014 -AutoFix -Force

Checks to see if the server name is updatable and automatically performs the change, bypassing most prompts and confirmations. Replication or mirroring will be broken if necessary.

Required Parameters

-SqlInstance

The target SQL Server instance or instances.

Optional Parameters

-SqlCredential

Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.
For MFA support, please use Connect-DbaInstance.

-AutoFix

Automatically resolves blockers that prevent the server name repair, including removing replication distribution and disabling database mirroring.
Use this when you need to fix the server name without manual intervention to remove these blocking configurations.
This parameter will prompt for confirmation before breaking replication or mirroring unless combined with -Force.

-Force

Bypasses confirmation prompts for potentially destructive operations like stopping SQL services and breaking replication or mirroring.
Use this for unattended automation or when you're certain about proceeding with all changes.
Combine with -AutoFix for fully automated server name repairs without any prompts.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

-WhatIf

If this switch is enabled, no actions are performed but informational messages will be displayed that explain what would happen if the command were to run.

-Confirm

If this switch is enabled, you will be prompted for confirmation before executing any operations that change state.