Tuesday, December 25, 2012

SharePoint 2013 Installation

For the runing of the SharePoint Wizard the SQL advanced option "max degree of parallelism" must be set to 1. If this advanced option is not set before runing the wizard and the current Account does not have more than the standard rights (Security Admin, DB Creater),the setup fails.

http://msdn.microsoft.com/de-de/library/ms181007%28v=sql.90%29.aspx

sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO

Wednesday, July 18, 2012

SharePoint 2013 Templates

This islist of the template available in SharePoint 2013 ( Get-SPWebTemplate)

Templates available in the 15 mode


Name Title LocaleId
GLOBAL#0 Global template 1033
STS#0 Team Site 1033
STS#1 Blank Site 1033
STS#2 Document Workspace 1033
MPS#0 Basic Meeting Workspace 1033
MPS#1 Blank Meeting Workspace 1033
MPS#2 Decision Meeting Workspace 1033
MPS#3 Social Meeting Workspace 1033
MPS#4 Multipage Meeting Workspace 1033
CENTRALADMIN#0 Central Admin Site 1033
WIKI#0 Wiki Site 1033
BLOG#0 Blog 1033
SGS#0 Group Work Site 1033
TENANTADMIN#0 Tenant Admin Site 1033
APP#0 App Template 1033
APPCATALOG#0 App Catalog Site 1033
ACCSRV#0 Access Services Site 1033
ACCSVC#0 Access Services Site Internal 1033
ACCSVC#1 Access Services Site 1033
BDR#0 Document Center 1033
DEV#0 Developer Site 1033
DOCMARKETPLACESITE#0 Academic Library 1033
EDISC#0 Discovery Center 1033
EDISC#1 Discovery Case 1033
OFFILE#0 (obsolete) Records Center 1033
OFFILE#1 Records Center 1033
OSRV#0 Shared Services Administration Site 1033
PPSMASite#0 PerformancePoint 1033
BICenterSite#0 Business Intelligence Center 1033
SPS#0 SharePoint Portal Server Site 1033
SPSPERS#0 SharePoint Portal Server Personal Space 1033
SPSPERS#2 Storage And Social SharePoint Portal ...  1033
SPSPERS#3 Storage Only SharePoint Portal Server… 1033
SPSPERS#4 Social Only SharePoint Portal Server … 1033
SPSPERS#5 Empty SharePoint Portal Server Person… 1033
SPSMSITE#0 Personalization Site 1033
SPSTOC#0 Contents area Template 1033
SPSTOPIC#0 Topic area template 1033
SPSNEWS#0 News Site 1033
CMSPUBLISHING#0 Publishing Site 1033
BLANKINTERNET#0 Publishing Site 1033
BLANKINTERNET#1 Press Releases Site 1033
BLANKINTERNET#2 Publishing Site with Workflow 1033
SPSNHOME#0 News Site 1033
SPSSITES#0 Site Directory 1033
SPSCOMMU#0 Community area template 1033
SPSREPORTCENTER#0 Report Center 1033
SPSPORTAL#0 Collaboration Portal 1033
SRCHCEN#0 Enterprise Search Center 1033
PROFILES#0 Profiles 1033
BLANKINTERNETCONT...  Publishing Portal 1033
SPSMSITEHOST#0 My Site Host 1033
ENTERWIKI#0 Enterprise Wiki 1033
PROJECTSITE#0 Project Site 1033
PRODUCTCATALOG#0 Product Catalog 1033
COMMUNITY#0 Community Site 1033
COMMUNITYPORTAL#0 Community Portal 1033
SRCHCENTERLITE#0 Basic Search Center 1033
SRCHCENTERLITE#1 Basic Search Center 1033
visprus#0 Visio Process Repository 1033






Templates available in the 14 mode


Name Title LocaleId
GLOBAL#0 Global template 1033
STS#0 Team Site 1033
STS#1 Blank Site 1033
STS#2 Document Workspace 1033
MPS#0 Basic Meeting Workspace 1033
MPS#1 Blank Meeting Workspace 1033
MPS#2 Decision Meeting Workspace 1033
MPS#3 Social Meeting Workspace 1033
MPS#4 Multipage Meeting Workspace 1033
CENTRALADMIN#0 Central Admin Site 1033
WIKI#0 Wiki Site 1033
BLOG#0 Blog 1033
SGS#0 Group Work Site 1033
TENANTADMIN#0 Tenant Admin Site 1033
ACCSRV#0 Access Services Site 1033
ACCSRV#1 Assets Web Database 1033
ACCSRV#3 Charitable Contributions Web Database 1033
ACCSRV#4 Contacts Web Database 1033
ACCSRV#6 Issues Web Database 1033
ACCSRV#5 Projects Web Database 1033
BDR#0 Document Center 1033
OFFILE#0 (obsolete) Records Center 1033
OFFILE#1 Records Center 1033
OSRV#0 Shared Services Administration Site 1033
PPSMASite#0 PerformancePoint 1033
BICenterSite#0 Business Intelligence Center 1033
SPS#0 SharePoint Portal Server Site 1033
SPSPERS#0 SharePoint Portal Server Personal Space 1033
SPSMSITE#0 Personalization Site 1033
SPSTOC#0 Contents area Template 1033
SPSTOPIC#0 Topic area template 1033
SPSNEWS#0 News Site 1033
CMSPUBLISHING#0 Publishing Site 1033
BLANKINTERNET#0 Publishing Site 1033
BLANKINTERNET#1 Press Releases Site 1033
BLANKINTERNET#2 Publishing Site with Workflow 1033
SPSNHOME#0 News Site 1033
SPSSITES#0 Site Directory 1033
SPSCOMMU#0 Community area template 1033
SPSREPORTCENTER#0 Report Center 1033
SPSPORTAL#0 Collaboration Portal 1033
SRCHCEN#0 Enterprise Search Center 1033
PROFILES#0 Profiles 1033
BLANKINTERNETCONT… Publishing Portal 1033
SPSMSITEHOST#0 My Site Host 1033
ENTERWIKI#0 Enterprise Wiki 1033
SRCHCENTERLITE#0 Basic Search Center 1033
SRCHCENTERLITE#1 Basic Search Center 1033
SRCHCENTERFAST#0 FAST Search Center 1033
visprus#0 Visio Process Repository 1033

SharePoint 2013

First Impression of SharePoint 2013 Team Site collection


Backup and Restore of Managed Meta Data Term Store


Backup:
$mmsApplication = Get-SPServiceApplication | ? {$_.TypeName –eq “Managed Metadata Service”}
$mmsProxy = Get-SPServiceApplicationProxy | ? {$_.TypeName –eq “Managed Metadata Service Connection”}
Export-SPMetadataWebServicePartitionData $mmsApplication.Id –ServiceProxy $mmsProxy –Path “C:\Temp\mmsbackup.cab”


Restore:
$mmsApplication = Get-SPServiceApplication | ? {$_.TypeName –eq “Managed Metadata Service”}
$mmsProxy = Get-SPServiceApplicationProxy | ? {$_.TypeName –eq “Managed Metadata Service Connection”}
Import-SPMetadataWebServicePartitionData $mmsApplication.Id –ServiceProxy $mmsProxy –Path “C:\Temp\mmsbackup.cab” –OverwriteExisting

Sunday, October 9, 2011

Installation of SharePoint SP1 - 14.0.6106.5002

This blog describes the installeion of SP1 an a multi server farm with 7 installed language packages, 

Known issues when you install Office 2010 SP1 and SharePoint 2010 SP1


Installation Order
WEF (Central Admin)
WEF
APP

Stop this services
  • net stop "World Wide Web Publishing Service"
  • net stop "Microsoft Office Project Server Queue Service"
  • powershell /Executionpolicy Unrestricted /File "%~d0%~p0Tools\createNewFarm.ps1"
Get-SPServiceInstance | where-object {$_.TypeName -eq "User Profile Synchronization Service"} | Stop-SPServiceInstance -Confirm:$false

Here is the installation process:
 
1. Office Web App Hotfix (http://support.microsoft.com/kb/2532126)
excelwebapp-kb2510639-fullfile-x64-glb.exe /log:C:\SP1.Install\excelwebapp-kb2510639.log /quiet /norestart
excelwebapp-kb2510648-fullfile-x64-glb.exe /log:C:\SP1.Install\excelwebapp-kb2510648.log /quiet /norestart

2. REBOOT

3. Microsoft SharePoint Foundation 2010 SP1
sharepointfoundation2010sp1-kb2460058-x64-fullfile-en-us.exe /log:C:\SP1.Install\sharepointfoundation2010sp1-kb2460058.log /quiet /norestart

4. Microsoft SharePoint Foundation 2010 Language Pack 2010 SP1
Chinese (PRC)
spflanguagepack2010sp1-kb2460059-x64-fullfile-zh-tw.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-zh.log /quiet /norestart
French
spflanguagepack2010sp1-kb2460059-x64-fullfile-fr-fr.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-fr.log /quiet /norestart
German
spflanguagepack2010sp1-kb2460059-x64-fullfile-de-de.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-de.log /quiet /norestart
Italian
spflanguagepack2010sp1-kb2460059-x64-fullfile-it-it.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-it.log /quiet /norestart
Japanese
spflanguagepack2010sp1-kb2460059-x64-fullfile-ja-jp.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-ja.log /quiet /norestart
Portuguese
spflanguagepack2010sp1-kb2460059-x64-fullfile-pt-pt.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-pt.log /quiet /norestart
Spanish
spflanguagepack2010sp1-kb2460059-x64-fullfile-es-es.exe /log:C:\SP1.Install\spflanguagepack2010sp1-kb2460059-es.log /quiet /norestart
5. SharePoint Foundation 2010 hotfix package June 30
sharepointfoundation2010-kb2553931-fullfile-x64-glb.exe /log:C:\SP1.Install\sharepointfoundation2010-kb2553931.log /quiet /norestart

6. REBOOT

7. Microsoft SharePoint and Project Server 2010 SP1
officeserver2010sp1-kb2460045-x64-fullfile-en-us.exe /log:C:\SP1.Install\officeserver2010sp1-kb2460045.log /quiet /norestart

8. Microsoft 2010 Servers Language Pack SP1
Chinese (PRC)
serverlanguagepack2010sp1-kb2460056-x64-fullfile-zh-tw.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-zh.log /quiet /norestart
French
serverlanguagepack2010sp1-kb2460056-x64-fullfile-fr-fr.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-fr.log /quiet /norestart
German
serverlanguagepack2010sp1-kb2460056-x64-fullfile-de-de.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-de.log /quiet /norestart
Italian
serverlanguagepack2010sp1-kb2460056-x64-fullfile-it-it.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-it.log /quiet /norestart
Japanese
serverlanguagepack2010sp1-kb2460056-x64-fullfile-ja-jp.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-ja.log /quiet /norestart
Portuguese
serverlanguagepack2010sp1-kb2460056-x64-fullfile-pt-pt.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-pt.log /quiet /norestart
Spanish
serverlanguagepack2010sp1-kb2460056-x64-fullfile-es-es.exe /log:C:\SP1.Install\serverlanguagepack2010sp1-kb2460056-es.log /quiet /norestart

9. SharePoint Server 2010 cumulative update June 30
office2010-kb2536599-fullfile-x64-glb.exe /log:C:\SP1.Install\office2010-kb2536599.log /quiet /norestart

10. Microsoft Office Web Apps SP1
wacserver2010sp1-kb2460073-x64-fullfile-en-us.exe /log:C:\SP1.Install\wacserver2010sp1-kb2460073.log /quiet /norestart

11. Microsoft Office Web Apps cumulative update June 30
webapps-kb2553919-fullfile-x64-glb.exe /log:C:\SP1.Install\webapps-kb2553919.log /quiet /norestart

12. REBOOT
13. Configuration Wizard:
WEF (Central Admin)
PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures -cmd installcheck -noinstallcheck
And then on all other SharePoint servers
psconfig.exe -cmd upgrade -inplace b2b -wait

Wednesday, August 11, 2010

SQL Scripts

List of all checked out files for an web applications:

SELECT
    sites.FullUrl AS SiteURL, tp_DirName AS Directory,  tp_LeafName AS Document,  [tp_CheckoutUserId] AS UserID

FROM 
[cms-roche.dev].[dbo].[AllUserData]

INNER JOIN 
[cms-roche.dev].dbo.[Sites] on sites.id=alluserdata.tp_SiteId

WHERE
[tp_CheckoutUserId]<>0

 

List of all activated Features for a web applciation:

SELECT 
sites.FullUrl AS SiteCollection,  Webs.FullUrl AS Site,  Features.FeatureId

FROM 
[cms-roche.dev].[dbo].[Features]

INNER JOIN 
[cms-roche.dev].dbo.Sites ON Features.SiteId=sites.Id

INNER JOIN 
[cms-roche.dev].dbo.Webs ON Features.WebId=Webs.Id

WHERE 
Features.FeatureId='00BFEA71-3A1D-41D3-A0EE-651D11570120'

Sunday, July 18, 2010

Hide a List with SharePoint Designer 2010

With SharePoint Designer 2010 it is possible to hide a list.

Just select the list an enable hidden

clip_image001

If you want to hide a list please uncheck "Display this ilist on the Quick Launch" otherwise you can not hide the list

After saving this works realy fine. You also would not see the list in SharePoint Designer again.

You can if you know the URL browse to the list and work with this list, but you can not configure it in SharePoint Designer.

There is a way to make the hidden list available again.

Select in SharePoint Designer in "All Files"/Lists with a right click the hidden list.

clip_image002

Then choose Properties

Now you can change all settings in SharePoint Designer and also change the hidden attribute

clip_image003