Monday, September 9, 2013

Replicating Directory Changes for SharePoint 2013 User Profile service account

Steps to grant this service account the permission to replicate the changes from SharePoint 2013 to Active Directory so follow these steps :

  1. Open Active Directory Users and Computers
  2. Right Click on Domain Name and select properties
  3. Go to security Tab and click Add button and add the service account
  4. From permission section check "Replicating Directory Changes" and click OK

Sunday, September 8, 2013

Excluded Folders from scanning in SharePoint 2013

These are the excluded folders from scanning by antivirus.


  • 15/Logs 
  • Microsoft Office Servers/15.0/Bin
  • Microsoft Office Servers/15.0/Data
  • Microsoft Office Servers/15.0/Logs
  • Microsoft Office Servers/15.0/Synchronization Service
  • Windows/System32/LogFiles
  • Windows/SysWOW64/LogFiles
  • [For each service accounts]
    users/sp_service_accounts/AppData/Local/Temp

Ref :http://support.microsoft.com/kb/952167

Saturday, September 7, 2013

People Picker in SharePoint 2013

We can manage how to query users in People picker using stsadm as the following (You can run these commands in SharePoint Management Shell ) :

  1. To enable Cross Domain (One way )
    stsadm -o setproprety -pn peoplepicker-searchadforests -pv "foreset:domain.com,domain\abc,password;domain:domain2.com,domain2\abc,password" -url http://domain.com
  2. Only show certain users or groups
    stsadm -o setsiteuseraccountdirectorypath -path "OU=Users,DC=Domain,DC=Com" -url http://domain.com
  3. Only show Users in Site collection
    stsadm -o setproperty -pn peoplepicker-onlysearchwithinsitecollection -pv yes -url http://domain
  4. Only show enabled accounts (using filter)
    stsadm -o setproperty -pn peoplepicker-searchadcustomfilter -pv "(*(objectCategory=person)(objectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2))" -url http://domain
  5. Only show Non AD accounts
    stsadm -o setproperty -pn peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode -pv yes -url http://domain


Office Web Apps with SharePoint 2013

Prerequisites to install Office Web Apps on a separate Server

  1. Joint to Domain
  2. Application Server and web Server Roles
  3. .Net Framework 3.5 , 4.5 Features
Install Office Web Apps 
  1. Run the setup 
  2. Create a Farm by using power shell
  3. New-OfficeWebAppsFarm -InternalURL http://ServerName -AllowHttp -EditingEnabledNote (You can configure -ExternalURL to access the site from load balance or from outside)
  4. Open http://ServerName/hosting/discovery and if you get a result then every thing is Ok
    Note (to add a second server to Office Web Apps farm run the following after you install Office Web Apps New-OfficeWebAppsMachine -MachineTojoin "First Server FQDN Server Name" )


Integrate SharePoint 2013 with Office Web Apps
  1. Open SharePoint Management Shell
  2. Run the following :
  3. New-SPWOPIBinding -ServerName officeWebAppsServerName.domain.local -AllowHttp
    Set-SPWOPIZone -Zone "internal-http"
    (because by default it's Https)
    $c = Get-SPSecurityTokeyServiceConfgi
    $c.AllowOAuthOverHttp = $true
    $c.Update()
  4. Test it from SharePoint site.

Steps to configure a Corporate Catalog

Steps to configure a corporate Catalog to host apps in SharePoint 2013 as following :

  1. Configure DNS to accept *.domain.com
    1. Open DNS
    2. Go to Forward Lookup Zones and right click and choose New zone...
    3. Click next and choose Primary zone and click Next
    4. keep the default settings and click next
    5. enter the zone name as for example "domain.local" and click next
    6. click next  and then finish
    7. Right click on "domain.local" and choose New Alias (CNAME...)
    8. enter the alias name as "*" and enter the FQDN as for example "apps.domain.local" and then ok
    9. you can test the above steps by ping for example a111.domain.local
  2. Go to Central administration and click on manage services on server
    1. start App Management Service
    2. start Microsoft SharePoint Foundation Subscription Settings Service
  3. Go to Centeral adminisrration and click on manage service applications
    1. Create a New App Management Service Application
    2. run the following powershell commands (Can't create this service from UI)
    3. $a = New-SPSubscriptionSettingsServiceApplication -applicationPool $pool -Name "Subscription settings" -DatabaseName SubScriptionSettings
    4. New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $a
  4. Go to Central administration and click on Apps link
    1. click on Configure App URLs
    2. enter the app domain "domain.local' and prefix as "apps"
    3. click on Manage App Catalog and Create a new app catalog site and click OK
    4. create a site collection

  5. Go to Central administration and click on Apps link
    1. from here you can manage settings , permission and purshase apps from internet

Tips for SharePoint 2013




  1. Creating a Web application with classic mode has deprecated but still you can create it using power shell.
  2. SharePoint Designer Settings are configured from Central administration for web application scope and from site settings of Site collection for Site Collection scope.
  3. Custom List does not has Incoming email option.
  4. You can create a Custom Service Application Proxy Group for multiple web applications only by using power shell :
    New-SPServiceApplicationProxyGroup "Custom_Proxy_Name"
  5. To use SharePoint 2013 Workflow you need to install Windows Azure Workflow add-on and then run the following command in SharePoint server to Create a Service application
    Register-SPWorkflowService
  6. Guide for How to Configure Kerosene in SharePoint 2013
    http://blog.blksthl.com/2012/09/26/the-first-kerberos-guide-for-sharepoint-2013-technicians/
  7. Create a trust between Farms in SharePoint 2013 using SPTrustedSecurityTokeyIssuer
    http://blogs.technet.com/b/speschka/archive/2012/07/23/setting-up-an-oauth-trust-between-farms-in-sharepoint-2013.aspx
  8. If you restore a Farm backup content and settings make sure User Profile sync job is not running because this will cause to failing the restoring.
  9. If you backup a site collection from UI then you can't edit the site during the backup process but you can via powershell -UseSqlSnapshot (need Enterprise SQL Server ) or -NoSiteLock to force it not to lock the site during backup process.
  10. You can use Machine translation with Managed Meta data.
  11. No need to install language packs to enable Managed Meta data to support multiple languages.
  12. Prerequisites log folder c:\Users\sp_farm\Appdata\local\temp\prerequisiteinstaller*.log
  13. You can't change Content Type hub URL after you added from UI and you can only change it from power shell
  14. Set-SPMetadataServiceApplication -Identity "<ServiceApplication>" -HubURI "<HubURI>"
  15. Make sure to allow connection in Web part security from Central administration when you want to connect between web parts.

  16. Guide for Rights Management in SharePoint 2013
    http://blogs.office.com/b/sharepoint/archive/2012/11/09/what-s-new-with-information-rights-management-in-sharepoint-and-sharepoint-online.aspx
    http://sp-vinod.blogspot.com/2013/08/configuring-information-rights.html
  17. If you create a page based on friendly URL then you delete the term from Managed Metadata you need also to delete the page from the library to totally delete that link.
  18. /_layouts/15/osssearchresults.aspx only search inside the SharePoint site collection so if you have crawled file shared then you need to create Search Center to get results from there.
  19. Query Logging is Disable By Default.
  20. Get-SPLogEvent to read SharePoint Logs
  21. To merge multiple logs file from different server use
    Merge-SPLogFile -Path c:\mylogs
  22. To show logs in UI
    Get-SPLogFile -File c:\mylogs -StartTime 1:30 | Select * | Out-GridView or Export-svc
  23. SharePoint Active Directory in User Profile Service Just Import Profiles.
  24. Health Analyzer related to Usage Service Application.
  25. You can Set Global Search URL from Search Administration.
  26. To get list of fronted servers in the Farm
    Get-SPServiceInstance | ? {$_.TypeName -eq 'Microsoft SharePoint Foundation web Application' -and $_.Status -eq 'Online'}
  27. How to plan for Distrubuted Cache Service http://sharepoint-community.net/profiles/blogs/distributed-cache-appfabrikcache-on-sharepoint-server-2013-part-1
  28. It's recommanded to avoid running Distrubeted Cache service in Server which has Search , project ,SQL or excel services.
  29. You can create a site column directly from inline editing of the list





Host Name Site Collection in SharePoint 2013

Steps to create a Host Name Site collection in SharePoint 2013 :

  1. Open SharePoint Management Shell
  2. Run the Following Command 

New-SPSite -Url "http://HostheaderForSiteCollection" -HostHeaderWebApplication "http://WebAppUrl" -Name "Test Name" -Template "sts#0" -OwnerAlias "domain\userDomain"

Friday, September 6, 2013

Steps to create DNS entry (A Record)


Steps to create A DNS record :
  1. Open DNS
  2. Go to Forward Lookup Zones
  3. Right click on domain name and choose New Host (A or AAA..)
  4. Then insert the name for example (intranet) and IP address
  5. Then Click Add Host.

Wednesday, September 4, 2013

Open Port 1433 in Windows Firewall with Advanced Security

To open SQL port 1433 (or any port you configured) to enable SharePoint 2013 to communicate with SQL Server you need to do the following :

  1. Login to SQL Server
  2. Open Windows Firewall with Advanced Security
  3. In Inbound Rules .. Click New Rule
  4. Choose Port option and click Next
  5. Choose TCP option and insert the port (1433) and then click Next
  6. Choose Allow the connection option and click Next
  7. Only Check Domain option and click Next
  8. Inset a Name for the rule like 'SQL Server' and click Finish