Build SharePoint 2010 Farm without Database GUIDs
When setting up SharePoint, often its an annoyance from DBAs perspective, SharePoint adds GUIDs with Database names.
Is there a way to build without GUIDs? Yes, PowerShell is your friend. Here is how:
For Configuration Database:
Once the installation is over, uncheck the “Run Product & technologies configuration wizard” checkbox. Fire the PowerShell for SharePoint, and enter the below commands:
New-SPConfigurationDatabase -DatabaseName SP2010_Farm_Config
-DatabaseServer <Database Server Name> -AdministrationContentDatabaseName SP2010_Farm_AdminContent
You can use the above PowerShell commands to build a Standalone SharePoint 2010 environment with Local user account!
When prompted for user name password: Enter Domain\username. Once completed, run the Products and technologies configuration wizard!
Create Search Service application without Database GUIDs
#Set the initial variables.
$Search_Service_name = "Search Service Application"
$Search_Service_account = "G1vsptst01\Administrator"
$Search_Service_Instance = get-spenterprisesearchserviceinstance -local
# Start Services search services for Search Service Application
Start-SPEnterpriseSearchServiceInstance -Identity $Search_Service_Instance
# Create an Application Pool.
$AppPool = new-SPServiceApplicationPool -name "Search Service App Pool" -account $Search_Service_account
# Create the SearchApplicationlication and set it to a variable
$SearchApplication = New-SPEnterpriseSearchServiceApplication -Name $Search_Service_name -applicationpool $AppPool -databasename "SP2010_Farm_SearchService"
# Create search service application proxy
$Search_Service_Proxy = new-spenterprisesearchserviceapplicationproxy -name "SearchApplicationProxy" -Uri $SearchApplication.Uri.AbsoluteURI
# Provision Search Admin Component.
set-SPenterprisesearchadministrationcomponent -SearchApplication $SearchApplication -searchserviceinstance $Search_Service_Instance
Now, From this point on, you can configure the index and crawl components from central admin.
For Web Analytics
#Web Analytics Service and Proxy
$saAppPool = Get-SPServiceApplicationPool -Identity "Service Application App Pool" -EA 0
$stagerSubscription = ""
$reportingSubscription = ""
New-SPWebAnalyticsServiceApplication -Name "Web Analytics Service Application" -ApplicationPool $saAppPool -ReportingDataRetention 20 -SamplingRate 100 -ListOfReportingDatabases $reportingSubscription -ListOfStagingDatabases $stagerSubscription > $null
New-SPWebAnalyticsServiceApplicationProxy -Name "Web Analytics Proxy" -ServiceApplication "Web Analytics Service Application" > $null
Get-SPServiceInstance | where-object {$_.TypeName -eq "Web Analytics Web Service"} | Start-SPServiceInstance > $null
Get-SPServiceInstance | where-object {$_.TypeName -eq "Web Analytics Data Processing Service"} | Start-SPServiceInstance > $null
Update: Auto-SPInstaller https://github.com/brianlala/AutoSPInstaller makes everything simpler! give it a try!!
More Info:
https://blogs.msmvps.com/shane/2010/10/26/getting-rid-of-guids-in-sharepoint-2010-database-names/
https://toddcarter.wordpress.com/2010/04/26/the-wizard-likes-his-guids/