How to Change Configuration Manager Site Name: Two Easy Methods

How to Change Configuration Manager Site Name: Two Easy Methods.

Method 1: Using SQL Management Studio

1. Launch SQL Server Management Studio. Click Connect and that should show the SQL server. Expand Databases and then expand the site database.
2. Expand Tables and look for a table named dbo.SC_SiteDefinition. Right-click dbo.SC_SiteDefinition and click Edit Top 200 Rows.
3. On the right pane, look for a column called SiteName. The name displayed under SiteName is your current site name.
4. There is no restart required after making the above changes. Close the SCCM console and reopen the console. Navigate to Administration > Overview > Site Configuration > Sites. Select the server, right click and click Properties. Check the new name.

Method 2: Using PowerShell and WMI

1. Create an object of the SiteDefinition that we want to change.
2. Change the property SiteName to our new name.
3. Save the changes.

[CmdletBinding()]
param (
[string]$SiteCode,
[string]$SiteServer,
[string]$SiteName
)
function Change-SiteName {
$Site = Get-WmiObject -Class SMS_SCI_SiteDefinition -Namespace root/SMS/site_$($SiteCode) -ComputerName $SiteServer | Where-Object -FilterScript {$_.SiteCode -eq $SiteCode}
$Site.SiteName = $SiteName
$Site.Put()
}
Change-SiteName

PowerShell.exe -ExecutionPolicy ByPass .\ChangeSiteName_v1_0.ps1 -SiteCode <SiteCode> -SiteServer <SiteServer> -SiteName <SiteName>