General SharePoint Service Application resources

 

 

Make Business Data Available in SharePoint 2013GP0|#f191bcd8-7f86-4edd-81fb-ca0777612ff2;L0|#0f191bcd8-7f86-4edd-81fb-ca0777612ff2|Business Data Connectivity Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213While SharePoint 2013 comes with lots of different content types and data, sometimes you really want to pull data from an existing business system. In this video excerpt from Scot Hillier's new course SharePoint 2013 Business Connectivity Services Fundamentals you'll see how to leverage SharePoint's built-in features for connecting to external data to create a custom content type for your in your SharePoint 2013 sites. In the full course Scot also covers authentication, creating external lists, and searching external systems.
Opening a SharePoint Online List with AccessGP0|#530b6139-3f73-415a-b7b8-3dbd1d0aa6e3;L0|#0530b6139-3f73-415a-b7b8-3dbd1d0aa6e3|Access Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213This video shows you how to update a SharePoint list using Microsoft Access
Move SharePoint 2013 Search Index LocationGP0|#1a8f085c-40e9-4a01-b25b-abeddf498837;L0|#01a8f085c-40e9-4a01-b25b-abeddf498837|Search Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​SharePoint 2013 makes heavy use of the file system for the Index Partition. By default this is placed on the system drive. You should plan to use a dedicated drive for the partition and it must exist as the same drive letter on any replica servers. 100Gb per TB of content is a rough estimate of the sapce required. This script will let you move it if it is only deplyed to one server.
SharePoint user profile properties now writable with CSOMGP0|#81c8ff8d-50a8-4de2-84e7-c5e478b09017;L0|#081c8ff8d-50a8-4de2-84e7-c5e478b09017|CSCOM;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#416f8251-f4d5-40dc-be28-d7400d10de85;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b5ca10cd-3b9e-486c-9290-c7a8c5cd6740;L0|#0b5ca10cd-3b9e-486c-9290-c7a8c5cd6740|User Profile Service;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​Native support for updating user profile properties with CSOM in Office 365is included in the latest version of the CSOM package (3rd of Sep 2014 or newer).
Inside SharePoint Secure Store Service (SSS) Database, Auditing, SSS ActivityGP0|#6e558226-a9d0-4eca-a33e-d3f5624a06f5;L0|#06e558226-a9d0-4eca-a33e-d3f5624a06f5|Secure Store Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​How to enable database auditing of the Secure Store Service
Re-enable the PremiumSite Feature after removing PowerPivotGP0|#be9f6e37-d079-4e4e-84f3-416739395df1;L0|#0be9f6e37-d079-4e4e-84f3-416739395df1|PowerPivot;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​After you uninstall the PowerPivot for SharePoint component, Excel Services and other services in the PremiumSite feature are disabled. To re-enable the features for all the SharePoint sites in a SharePoint farm, run the following script
feature event receiver for BCS deploymentGP0|#f191bcd8-7f86-4edd-81fb-ca0777612ff2;L0|#0f191bcd8-7f86-4edd-81fb-ca0777612ff2|Business Data Connectivity Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 This feature receiver will dynamically set the site collection url where the external content type is being activated.
Microsoft BI Authentication and Identity DelegationGP0|#6553c9ac-7cd3-4c35-9ee0-494641495101;L0|#06553c9ac-7cd3-4c35-9ee0-494641495101|Authentication;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GP0|#1da233f4-dc04-4361-9f9b-16d4053ca898;L0|#01da233f4-dc04-4361-9f9b-16d4053ca898|Performance Point;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1 ​From straightforward client/server designs to complex architectures relying on distributed Windows services, SharePoint applications, Web services, and data sources, Microsoft BI solutions can pose many challenges to seamless user authentication and end-to-end identity delegation. SQL Server technologies and data providers expect to use Windows authentication while SharePoint Server uses Web Services Security (WS-Security). Familiarity with the authentication protocols and capabilities, delegation limitations, and possible workarounds is an indispensable prerequisite to delivering a positive BI user experience across the entire Microsoft BI solution stack in enterprise environments.
Can't edit workbooks in the browser that have external data connectionsGP0|#b20346d4-3cda-4fd2-9603-5571a7e5e2db;L0|#0b20346d4-3cda-4fd2-9603-5571a7e5e2db|Upgrade;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GP0|#55fb27c6-9a9a-4c40-be08-4801ff88eeec;L0|#055fb27c6-9a9a-4c40-be08-4801ff88eeec|Excel Web Access;GPP|#7c66663a-64ea-4c65-9772-9b3a76b4aa65;GPP|#1bc09cbd-f411-45d5-ad40-bb6b715fb72f;GPP|#a5205c2f-ad79-446f-8d9e-afd0eeecf427 ​Workbooks with external data connections that use Windows authentication cannot be refreshed in the browser. Instead, you are prompted to open the workbook in the Excel client program. Workbooks that have database or Windows credentials stored either in the Secure Store Service or in the connection string can still be edited in the browser. This change applies only when Excel Web App in Office Web Apps Server is used to view workbooks, not when Excel Services in SharePoint Server 2013 is used. Note You can still refresh these workbooks in the Excel client program. Additionally, a service application administrator can configure that workbooks are viewed in SharePoint 2013 instead of Office Web Apps Server.
Change order of user profile properties in SharePoint 2013 with PowershellGP0|#e076f06d-face-4c15-b118-1c910704bfbb;L0|#0e076f06d-face-4c15-b118-1c910704bfbb|PowerShell;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#416f8251-f4d5-40dc-be28-d7400d10de85;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b5ca10cd-3b9e-486c-9290-c7a8c5cd6740;L0|#0b5ca10cd-3b9e-486c-9290-c7a8c5cd6740|User Profile Service;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​Management of user profile properties in SharePoint CA user interface is easy and intuitive, but when it comes to changing the display order of user profile properties, this becomes a difficult and frustrating task (and it has been like this since 2007). Powershell scripting proves again very handy.
Exposing external BCS content via search in SharePoint 2013GP0|#0b83bd4b-e1d8-4db2-b273-ee9f3f2efb1a;L0|#00b83bd4b-e1d8-4db2-b273-ee9f3f2efb1a|Search;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#a5205c2f-ad79-446f-8d9e-afd0eeecf427;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#f191bcd8-7f86-4edd-81fb-ca0777612ff2;L0|#0f191bcd8-7f86-4edd-81fb-ca0777612ff2|Business Data Connectivity Service;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​This article explains how you can expose external data through the Business Data Connectivity Service into search in SharePoint 2013.
Configuring Search Service Application and Topology using PowerShellGP0|#1a8f085c-40e9-4a01-b25b-abeddf498837;L0|#01a8f085c-40e9-4a01-b25b-abeddf498837|Search Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#e076f06d-face-4c15-b118-1c910704bfbb;L0|#0e076f06d-face-4c15-b118-1c910704bfbb|PowerShell;GPP|#416f8251-f4d5-40dc-be28-d7400d10de85 ​This article shows how to configure topology for one search service application with multiple search components across 2 servers for redundancy and performance.
Recreate the Sharepoint 2013 State Service GP0|#d77f5073-6769-4a90-84ec-753a868c524e;L0|#0d77f5073-6769-4a90-84ec-753a868c524e|State Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​This article will show you how you can re-create the “SharePoint Server ASP.NET Session State Service”, “State Service” and “State Service Proxy” for a default and non customized Sharepoint 2013 environment.
Fixing the AppFabric Cache Cluster in SharePoint 2013GP0|#302dd3c0-d2a4-4ac0-a877-00de0c1671d0;L0|#0302dd3c0-d2a4-4ac0-a877-00de0c1671d0|Distributed Cache;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​If the SharePoint Distributed Cace is not working (event log error, Search query not running, login failures etc) then it may be becuse the underlying AppFabric Cache Cluster is not working. Never use the AppFabric UI tool but this artical has good steps to validate the cluster is running OK.
Using a SharePoint List as a dataGP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​A trick using PowerPivot to allow SharePoint lists to be used as a datasource for a spreedsheet published in a library and displayed in a web part
Changing search topolgy causes disk space to be consumed until it runs outGP0|#1a8f085c-40e9-4a01-b25b-abeddf498837;L0|#01a8f085c-40e9-4a01-b25b-abeddf498837|Search Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213
Excel Services error "The workbook cannot be opened"GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213
http://blogs.msdn.com/b/kaevans/archive/2013/07/14/access-services-2013-setup-for-an-on-premises-installation.aspxGP0|#530b6139-3f73-415a-b7b8-3dbd1d0aa6e3;L0|#0530b6139-3f73-415a-b7b8-3dbd1d0aa6e3|Access Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​This blog post will show you how to set up Access Services 2013 in an on-premises installation.
SharePoint UPS Connector for FIM 2010 R2 GP0|#b5ca10cd-3b9e-486c-9290-c7a8c5cd6740;L0|#0b5ca10cd-3b9e-486c-9290-c7a8c5cd6740|User Profile Service;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​The SharePoint User Profile Store connector enables you manage SharePoint resources using FIM 2010 R2 SP1. The connector is available as a download from the Microsoft Download Center. This article provides the reference information that is required to deploy the SharePoint User Profile Store connector