If you use the wizard or the PowerShell command
Install-SPService
you will get a lot of databases with nice names
With the following PowerShell commands it looks a lot better:
Get-SPServiceApplicationPool
Name ProcessAccountName
---- ------------------
SecurityTokenServiceApplicationPool ALEGRIDEV\srvadmin
SharePoint Web Services Default ALEGRIDEV\srvadmin
SharePoint Web Services System ALEGRIDEV\srvadmin
Choose one of the services application pools
Activate Access Service:
New-SPAccessServiceApplication -Name "Access Database Service" -ApplicationPool "SharePoint Web Services Default"
DisplayName TypeName Id
----------- -------- --
Access Database S... Access Services W... 9921a156-1529-4e22-a903-e6fbcc74994d
Get-SPServiceInstance | where-object {$_.TypeName -eq "Access Database Service"} | Start-SPServiceInstance
TypeName Status Id
-------- ------ --
Access Database Service Provi... 00a4048c-481a-4124-a1db-0790d45549ef
Activate Application Usage:
new-spusuageapplication -name "Application Registry Service" -databasename "MOSS_Content_Usage"
Activate Business Data Catalog Service:
New-SPBusinessDataCatalogServiceApplication -Name "Business Data Connectivity Service" -ApplicationPool "SharePoint Web Services Default" -DatabaseName "MOSS_Content_BCS"
DisplayName TypeName Id
----------- -------- --
Business Data Con... Business Data Con... 288a04d0-6b66-4dbc-aaab-7124436ffd99
Activate Excel Services:
New-SPExcelServiceApplication -name "Excel Services" -ApplicationPool "SharePoint Web Services Default"
DisplayName TypeName Id
----------- -------- --
Excel Services Excel Services Ap... 6f980512-aa19-47ee-aeef-1bde4c9f1abc
Set-SPExcelFileLocation -Identity "http://" -ExcelServiceApplication "Excel Services" -ExternalDataAllowed 2 -WorkbookSizeMax 10 -WarnOnDataRefresh:$true
Activate Managed Metadata Service:
New-SPMetadataServiceApplication -Name "Managed Metadata Services" -ApplicationPool "SharePoint Web Services Default" -DatabaseServer "SA_MOSS" -DatabaseName "MOSS_Content_Metadata"
DisplayName TypeName Id
----------- -------- --
Managed Metadata ... Managed Metadata ... faade99a-e1ba-4083-83e4-ae94174cdf6d
New-SPMetadataServiceApplicationProxy -Name "Managed Metadata Services Proxy" -DefaultProxyGroup -ServiceApplication "Managed Metadata Services"
DisplayName TypeName Id
----------- -------- --
Managed Metadata ... Managed Metadata ... d713a6d4-d790-4b56-a025-b999a932f8bd
Activate PerformancePoint Service:
New-SPPerformancePointServiceApplication -Name "PerformancePoint Service" -ApplicationPool "SharePoint Web Services Default" -DatabaseServer "SA_MOSS" -DatabaseName "MOSS_Content_PerformancePoint"
Name : PerformancePoint Service
Id : 8979b9ea-cfca-462a-92cd-a61dca6331f5
Administrators : {c:0%.c|system|8b1f3671-667b-4a85-a60f-0fa4f2dc4ead}
ApplicationPool : SPIisWebServiceApplicationPool Name=SharePoint Web Services Default
CommentsDisabled : False
CommentsScorecardMax : 1000
SelectMeasureMaximum : 1000
DecompositionTreeMaximum : 250
IndicatorImageCacheSeconds : 10
DataSourceQueryTimeoutSeconds : 300
FilterRememberUserSelectionsDays : 90
FilterTreeMembersMax : 5000
ShowDetailsInitialRows : 1000
ShowDetailsMaxRowsDisabled : False
ShowDetailsMaxRows : 10000
TrustedDataSourceLocationsRestricted : False
TrustedContentLocationsRestricted : False
MSMQEnabled : False
MSMQName : .\Bpm
SessionHistoryHours : 10
AnalyticQueryLoggingEnabled : False
ApplicationProxyCacheEnabled : True
ApplicationCacheEnabled : True
ApplicationCacheMinimumHitCount : 2
ElementCacheSeconds : 15
DataSourceUnattendedServiceAccountUsername :
SettingsDatabase : SA_MOSS\\PerformancePoint Service_d00e597cf38d4656af64714aeda3cacf
AnalyticQueryCellMax : 100000
New-SPPerformancePointServiceApplicationProxy -Default -Name "PerformancePoint Service Proxy" -ServiceApplication "PerformancePoint Service"
DisplayName TypeName Id
----------- -------- --
PerformancePoint ... PerformancePoint ... 450e1aec-23ec-4cdf-b274-e1484fde9782
Activate PowerPoint Services:
New-SPPowerPointServiceApplication -Name “PowerPoint Service” -ApplicationPool "SharePoint Web Services Default"
DisplayName TypeName Id
----------- -------- --
PowerPoint Services PowerPoint Servic... c2340338-3971-4203-84e6-505a3d35a68e
New-SPPowerPointServiceApplicationProxy -Name "PowerPoint Service Proxy" -ServiceApplication "PowerPoint Service"
DisplayName TypeName Id
----------- -------- --
PowerPoint Servic... PowerPoint Servic... e8b8d619-2413-4999-a8e2-b7c513793ea4
Activate Search Service:
$Search = New-SPEnterpriseSearchServiceApplication -Name "Search Service" -ApplicationPool "SharePoint Web Services Default" -DatabaseServer "SA_MOSS" -DatabaseName "MOSS_Content_Search"
Name : Search Service
Id : ea2329db-fa10-4d64-9d20-934f25cd16bd
ServiceName : SearchQueryAndSiteSettingsService
QueryTopologies : {3040de2c-0530-48c8-8b0f-946115543ada}
PropertyStores : {MOSS_Content_Search_PropertyStore}
CrawlTopologies : {bbb21327-9301-4034-9209-163f45922ff3}
CrawlStores : {MOSS_Content_Search_CrawlStore}
SearchAdminDatabase : SearchAdminDatabase Name=MOSS_Content_Search
Status : Online
SearchApplicationType : Regular
DefaultSearchProvider : SharepointSearch
Properties : {Microsoft.Office.Server.Utilities.SPPartitionOptions}
$searchrun = Get-SPEnterpriseSearchServiceInstance "vmalegri"
Start-SPEnterpriseSearchServiceInstance "vmalegri"
Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance "vmalegri"
$search | Get-SPEnterpriseSearchAdministrationComponent | Set-SPEnterpriseSearchAdministrationComponent -SearchServiceInstance $searchrun
$CrawlTopology = $search | Get-SPEnterpriseSearchCrawlTopology -Active
$CrawlTopologyNew = $searchApp | New-SPEnterpriseSearchCrawlTopology
$CrawlDatabase = ([array]($search | Get-SPEnterpriseSearchCrawlDatabase))[0]
$CrawlComponent = New-SPEnterpriseSearchCrawlComponent -CrawlTopology $CrawlTopologyNew -CrawlDatabase $CrawlDatabase -SearchServiceInstance $searchRun
$CrawlTopologyNew | Set-SPEnterpriseSearchCrawlTopology -Active
do {write-host -NoNewline .;Start-Sleep 6;} while ($InitialCrawlTopology.State -ne "Inactive")
$CrawlTopology | Remove-SPEnterpriseSearchCrawlTopology
$QueryTopology = $search | Get-SPEnterpriseSearchQueryTopology -Active
$QueryTopologyNew = $search | New-SPEnterpriseSearchQueryTopology -Partitions 1
$IndexPartition= (Get-SPEnterpriseSearchIndexPartition -QueryTopology $QueryTopologyNew)
$QueryComponent = New-SPEnterpriseSearchQuerycomponent -QueryTopology
$QueryTopologyNew -IndexPartition $IndexPartition -SearchServiceInstance $searchrun
$PropertyDatabase = ([array]($search | Get-SPEnterpriseSearchPropertyDatabase))[0]
$IndexPartition | Set-SPEnterpriseSearchIndexPartition -PropertyDatabase $PropertyDatabase
$QueryTopologyNew | Set-SPEnterpriseSearchQueryTopology -Active
$searchAppProxy = New-SPEnterpriseSearchServiceApplicationProxy -Name "Search Service Proxy" -SearchApplication "Search Service"
Activate New State Service:
New-SPStateServiceDatabase -Name "MOSS_Content_StateService" -DatabaseServer "SA_MOSS" | New-SPStateServiceApplication -Name "State Service" | New-SPStateServiceApplicationProxy -Name "State Service Proxy" -DefaultProxyGroup
DisplayName TypeName Id
----------- -------- --
State Service Proxy State Service Proxy 420caaf5-29a6-4dca-9278-24fee11eef29
Activate Secure Store Service:
New-SPSecureStoreServiceapplication -Name "Secure Store Service" -Sharing:$false -DatabaseServer "SA_MOSS" -DatabaseName "MOSS_Content_SecureStore" -ApplicationPool "SharePoint Web Services Default" -auditingEnabled:$true -auditlogmaxsize 30 | New-SPSecureStoreServiceApplicationProxy -name "Secure Store Service Proxy" -DefaultProxygroup
DisplayName TypeName Id
----------- -------- --
Secure Store Serv... Secure Store Serv... b4f6de99-2323-4875-a03f-c0a2f1137263
Activate User Profile Service:
$userProfileService = New-SPProfileServiceApplication -Name "User Profile Synchronization Service" -ApplicationPool "SharePoint Web Services Default" -ProfileDBServer "SA_MOSS" -ProfileDBName "MOSS_Content_UserProfile" -SocialDBServer "SA_MOSS" -SocialDBName "MOSS_Content_UserSocial" -ProfileSyncDBServer "SA_MOSS" -ProfileSyncDBName "MOSS_Content_UserSync"
New-SPProfileServiceApplicationProxy -Name "User Profile Synchronization Service" -ServiceApplication $userProfileService -DefaultProxyGroup
Name Type Id
---- ---- --
User Profile Sync... User Profile Serv... e4d53a40-cd31-437e-85b5-ca9ccb0b2f6a
Get-SPServiceInstance | where-object {$_.TypeName -eq "User Profile Service"} | Start-SPServiceInstance
TypeName Status Id
-------- ------ --
User Profile Service Provi... 7bc15c13-c351-41c4-991d-726b756c98cc
Get-SPServiceInstance | where-object {$_.TypeName -eq "User Profile Synchronization Service"} | Start-SPServiceInstance
TypeName Status Id
-------- ------ --
User Profile Synchronization ... Provi... e7a7707a-0406-48f3-96e4-c45ba8422f96
Activate Visio Services:
New-SPVisioServiceApplication -Name "Visio Graphics Service" -ApplicationPool "SharePoint Web Services Default"
Name : visio Graphics Service
Id : 37d376c2-448f-4e77-8b72-d038c0416ab3
ApplicationPool : SPIisWebServiceApplicationPool Name=SharePoint Web Services Default
New-SPVisioServiceApplicationProxy -Name "Visio Graphics Service" -ServiceApplication "Visio Graphics Service"
Name : Visio Graphics Service
Id : 0fa40f47-f3cb-4822-b627-268d85b255cd
Activate Word Conversion Service:
New-SPWordConversionServiceApplication -Name "Word Conversion Service" -ApplicationPool "SharePoint Web Services Default" -DatabaseServer "SA_MOSS" -DatabaseName "MOSS_Content_WordAutomation" -Default
Name : Word Conversion Service
Id : 6b61483c-7b99-4519-9630-74af660bbcf5
ApplicationPool : SPIisWebServiceApplicationPool Name=SharePoint Web Services Default
Database : QueueDatabase Name=MOSS_Content_WordAutomation
Status : Online
Activate Word Viewing Service:
New-SPWordViewingServiceApplication -Name "Word Viewing Service" -ApplicationPool "SharePoint Web Services Default"
DisplayName TypeName Id
----------- -------- --
Word Viewing Service Word Viewing Serv... 7cbb597a-33da-4065-ba5b-67e1c9063e66
New-SPWordViewingServiceApplicationProxy -Name "Word Viewing Service Proxy" -ServiceApplication 7cbb597a-33da-4065-ba5b-67e1c9063e66
DisplayName TypeName Id
----------- -------- --
Word Viewing Serv... Word Viewing Serv... 31a3d4c1-5bbe-4f2a-94a7-b3b1ef50cc50
Some of the services need a IISReset to work properly
IISReset
Only one database name can not be configured
