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.
# use SP-farm account credentials
$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
New-SPCentralAdministration -Port 8080 -WindowsAuthProvider “NTLM”
# Set-SPDiagnosticConfig -LogLocation “C:\Logs”