Sharepoint 2010 Renaming Admin Content Database

Hi Readers,

Its been sometime now since I have posted anything new as I was on Vacation.

I came across a situation where you want to rename the Admin Content Database so as to remove the guild assigned to it.

You will find various articles on the internet for how to rename it but there is a caveat so I will say avoid it as some times after renaming the

this db “WSS_Content_Application_Pools” role gets removed from SQL db.

The best way is to have it named during Sharepoint installtion.

For example:–

—————————

# use SP-farm account credentials
Add-PSSnapin Microsoft.SharePoint.Powershell
$username = ‘DOMAIN\SP-FARM’
$password = ‘Passw0rd!’
$password = (ConvertTo-SecureString -String “$password” -AsPlainText -force)
$cred = New-Object System.Management.Automation.PsCredential $username,$password
New-SPConfigurationDatabase -DatabaseName “SP2010_Config” -DatabaseServer SharePoint_Alias -AdministrationContentDatabaseName “SP2010_CentralAdmin” -Passphrase (ConvertTo-SecureString “FarmAcctPassw0rd!” -AsPlainText -force) -FarmCredentials $cred
Install-SPHelpCollection -All
Initialize-SPResourceSecurity
Install-SPService
Install-SPFeature -AllExistingFeatures
New-SPCentralAdministration -Port 8080 -WindowsAuthProvider “NTLM”
Install-SPApplicationContent
# Set-SPDiagnosticConfig -LogLocation “C:\Logs”

—————————————————–

 

Regards

Sukhija Vikas

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s