Service Applications in SharePoint

Service Applications in SharePoint

I am trying to explain the service applications definitions in this article. Please make a comment if you feel any incorrect.

Access Services — This service application enables you to create, view, edit, and interact using either the access 2013 office client or in the browser.

Access Services 2010 — This service application enables continued maintenance of SharePoint 2010 Access service applications by using Access 2010 and 2013 Office clients. It does not enable users to create new applications.

App Management Service — The App Management Service enables you to install apps from the internal App Catalog or the public SharePoint store.

Business Data Connectivity Service — The Business Connectivity Service (BCS) enables you to upload data (BDC) models that define interfaces of other enterprise line-of-business (LOB) systems and enables connectivity to those systems.

Excel Services — This service application enables viewing and interacting with Excel files from within the browser.

Machine Translation Services — This service provides automatic machine translation of files and sites.

Managed Metadata Service — This service application enables you to manage taxonomy hierarchies, keywords, and social tagging features of SharePoint 2013. This service application also handles content-type publishing across site collections.

Performance Point — This service application supports configuration and monitoring of Performance Point as a business intelligence (BI) product integrated with the Enterprise edition of SharePoint 2013.

PowerPoint Automation Service — This service application enables server-side presentation conversions to and from a variety of file formats.

 Search Service — As its name implies, this service application (which comes with its own topology management configuration) is used to index content and serves search queries performed by users or custom code.

Secure Store Service — This is a credential mapping service to access other enterprise-level service applications or back-end enterprise systems.

State Service — The State Service provides temporary storage of any data that deals with a user session.

 Usage and Health Data Collection — This service application provides storage usage and health information at the farm level, and provides various reporting functionality on such data.

User Profile — This user profile service application is one of the core service applications in SharePoint 2013. This service application supports features such as My Sites, My links, Colleague tracker, profile pages, personal tags and notes, and other social features.

Visio Graphics Service — This service application enables viewing, interacting, and refreshing of Visio diagrams within a browser.

Word Automation Services — This service application enables you to view and edit Word documents in a web browser. It can also be used for document conversions.

Work Management Service — This Work Management Service enables key user-related information to be aggregated to a central location. The service supports a provider model to enable other systems to leverage this service.

Subscription Setting Service — This is the key enabling component of the Multitenancy features provided by the SharePoint 2013 platform

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Configuring the Excel Services Service Application in SharePoint 2013

Configuring the Excel Services Service Application in SharePoint 2013

The following steps describe how to create the Excel Services service application

1.    Log onto your SharePoint box as the Farm account.

2.    Open SharePoint Central Administration, and then select Manage service applications under the Application Management heading.

3.    From the Manage service applications screen, click the New button in the Ribbon. From the menu, select Excel Services Application.

                  

4.    For Name, enter Excel Services.

              

5.    Scroll down to Application Pool and select “Use existing application pool.”

6.    From the drop-down, select Default SharePoint Service App Pool.

7.    Leave the default of “Add this service application’s proxy to the farm’s default proxy list.”

8.    Click OK at the bottom of the page.

 To start the service application

10. From the left-hand menu, click Application Management.

11. Under the Service Applications section, click “Manage services on server.”

12. Find Excel Calculation Services and click Start to the right of it.
               

    
13. The Excel Services service application is now up and running, configured for SharePoint Users

14. should now be able to upload basic workbooks and view them inside of SharePoint.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!! -

The Security Token Service is not available. The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state

The Security Token Service is not available. The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

(Or) 

An exception occurred when trying to issue security token: Could not connect to http://localhost:2843/SecurityTokenServiceApplication/securitytoken.svc.TCP error code 10061: No connection could be made because the target machine actively refused it
(Or) 

The Managed Metadata Service '' is inaccessible.

Solution:

           Go to InetMgr(IIS manager)

1.    start the "SharePoint Web Services" site

2.    start the "SharePoint Web Services Root" application pool

3.      Do IIS reset.          

                        

                                                                         
                                                    

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Publishing service applications in sharepoint

Publishing service applications in sharepoint

                                                                                                   

          

               

Follow the below steps to publish the service applications between different farms.

Setting Up the Farm Trust

1. On the publishing server, create a folder at c:\PubCerts.

2. From the publishing server, open the SharePoint 2013 Management Shell. To get the certificate, type the following line and press Enter

        $rootCert = (Get-SPCertificateAuthority).RootCertificate

3. To export the certificate, type the following line and press Enter:

$rootCert.Export("Cert") | Set-Content C:\PubCerts\PublishingRoot.cer

-Encoding byte

4. Copy the c:\PubCerts folder from the publishing server to the consuming server.

5. On the consuming server, create a folder at c:\ConsumerCerts.

6. From the publishing server, open the SharePoint 2013 Management Shell.

7. To get the certificate, type the following line and press Enter:

          $rootCert = (Get-SPCertificateAuthority).RootCertificate

8. To export the certificate, type the following line and press Enter:

$rootCert.Export("Cert") | Set-Content C:\ConsumerCerts\ConsumingRoot.cer

-Encoding byte

9. To get the STS certificate, type the following line and press Enter:

$stsCert =(Get-SPSecurityTokenServiceConfig).LocalLoginProvider.SigningCertificate

10. To export the STS certificate, type the following line and press Enter:

$stsCert.Export("Cert") | Set-Content "C:\ConsumerCerts\ConsumingSTS.cer"

-Encoding byte

11. Copy the c:\ConsumerCerts folder to the publishing server.

12. Still on the consuming server, to load the publishing server’s certificate, type the following line and press Enter:

$trustCert = Get-PfxCertificate "C:\PubCerts\PublishingRoot.cer"

13. To set up the trust using the certificate, type the following line and press enter:

New-SPTrustedRootAuthority PublishingFarm -Certificate $trustCert

14. Return to the Management Shell on the publishing server.

15. To load the consuming server’s certifi cate, type the following line and press Enter:

$trustCert = Get-PfxCertificate "c:\ConsumerCerts\ConsumingRoot.cer"

16. To set up the trust using the certificate, type the following line and press Enter:

New-SPTrustedRootAuthority Collaboration -Certificate $trustCert

17. To load the consuming server’s STS certificate, type the following line and press Enter:

$stsCert = Get-PfxCertificate "c:\ConsumerCerts\ConsumingSTS.cer"

18. To add the STS certificate to the trust, type the following line and press Enter:

New-SPTrustedServiceTokenIssuer Collaboration -Certificate $stsCert

19. Return to the Management Shell on the consuming server.

20. Type the following line and press Enter:

Get-SPFarm | Select Id

21. Record that GUID for use later.

22. Return to the Management Shell on the publishing server.

23. To get the security object for the Application Discovery and Load Balancer service

application, type the following line and press Enter:

$security = Get-SPTopologyServiceApplication |

Get-SPServiceApplicationSecurity

24. To get the farm’s claim provider object, type the following line and press Enter:

$claimProvider = (Get-SPClaimProvider System).ClaimProvider

25. To set up the new claim principal for the consuming farm, type the following line and press

Enter:

$principal = New-SPClaimsPrincipal -ClaimType "http://schemas.microsoft.com

/sharepoint/2009/08/claims/farmid"

-ClaimProvider $claimProvider

-ClaimValue <Type the ID from Step 21, don't include the <>>

26. To give that principal permission in your publishing farm to the Application Discovery and

Load Balancer service application, type the following line and press Enter:

 Grant-SPObjectSecurity -Identity $security -Principal $principal

-Rights "Full Control"

27. To set the access just given, type the following line and press Enter:

 Get-SPTopologyServiceApplication | Set-SPServiceApplicationSecurity

-ObjectSecurity $security

That completes the process of establishing a trust between the two farms so that the publishing server can serve up service applications to the consuming farm. If you want to look at the trusts or possibly remove one, you can do that through the GUI by navigating to Central Administration ➪Security ➪ Manage trust.

Publishing a Service Application

For this task, you could dive back into Power Shell or you could use the GUI in Central

For this example, you will publish a Managed Metadata service application:

1. On the publishing server, open Central Administration.

2. Navigate to Application Management ➪ Manage service applications.

3. Click to the right of the service application you want to make available.

4. In the Ribbon, click Publish.

5. On the Publish Service Application page, check the box for “Publish this Service Application to other farms.”

6. For the Publish URL, copy all of the string that begins with “urn:” and ends with “.svc.”

For example, it will be similar to the following:

urn:schemas-microsoft-com:sharepoint:service:ac40e8f87daa43d9bec93f9fa99360c7

#authority=urn:uuid:de389296913c4f00b7970f50ea298fd4&authority=

https://server:32844/Topology/topology.svc

7. Scroll down the page and click OK.

8. Click to the right of the service application.

9. From the Ribbon, click Permissions.

10. Enter the farm ID of the consuming farm (refer to step 21 in the previous section, “Setting

Up the Farm Trust”). Click Add.

11. Highlight the remote farm: <Your Farm ID>.

12. For permissions, check the box to assign the permissions you wish to give to the remotefarm. The permissions available will vary according to the service application being published.

13. Open Central Administration on the consuming farm and navigate to Application

Management ➪ Manage service applications.

14. From the Ribbon, click Connect.

15. Enter the URL for the service application you want to access from step 6 in this section.

Click OK.

16. Click the service application name so that it is highlighted in yellow.

17. You can specify whether this service application should be included in the default service application group. When you are done, click OK.

18. Either accept the default connection name or enter your own. When you are fi nished,

click OK.

19. At the Success screen, click OK.

You can now work with the service application just as if it were part of your farm. 

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Service Application Commands

 Service Application Commands

                              

To get most of the cmdlets about service applications, run the following command from the SharePoint Management Shell:

                Get-Command *service application*

We will get all the commands related to service applications.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

We are sorry We ran into a problem completing your request

We are sorry We ran into a problem completing your request

                       

 Issue: Once uploaded all the Excel files in the SharePoint site. When we try to open the files in browser gives the error” We are sorry. We ran into a problem completing your request

 Cause: Excel services are not configured in farm to open the Excel sheets.

 Solution: Ensure to follow the below steps to resolve the issue.

· Ensure that the Excel Calculation Services  is in started state.

        Go to Application Management->Manage services on server under service       application

                    

                                      

     · Ensure that the Excel service Application configured and started properly.

      Go to Application Management->Manage services application under service             application

   

                                

Once Both the above steps done properly. Check To open the Excel in site.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

There was a problem retrieving data for this field. Updating values in the field is disabled temporarily. You can still update values in other fields.

Issue: There was a problem retrieving data for this field. Updating values in the field is disabled temporarily. You can still update values in other fields.                                                                     

                              

                                                                                                                                                            Cause: Properties containing these fields are linked to the Managed Metadata Service Application. These particular properties require a healthy Managed Metadata Service Application\Service Connection as well as associated (service instance) to be started    (or)
 The Managed Metadata Service Connection is missing from the associated proxy group

      Solution: Please check the below steps.

1.    Ensure the Managed Metadata Web Service started in application management->service application->manage services on server.

                           

         

2.    Ensure the service application “managed meta data service” created and started in Application management->service application->manage service application.

       

                

3.    If the Managed meta data service application is working fine, then data in the field will get update.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help!!!

A connection could be established to the application database server but mixed mode authentication isn’t enabled

A connection could be established to the application database server but Mixed mode authentication isn’t enabled.

  Back Ground: When I am trying to configure the Access services in SharePoint 2013 got the error.

 Cause: 

1.     For Configuration of access services in SharePoint 2013 it has to be SQL Server 2012,  It won’t work on SQL server 2008 or R2.  

2.     We need to provide the Application database server as SQL server 2012 only.                   

          3.     Note that you must have a SQL Server 2012 server to host these Access app databases. These databases don’t need to be on the same SQL Server as the rest of the SharePoint databases
       
      A very detailed article on How to configure Access services 2013

      http://www.sp2013blog.com/Lists/Posts/Post.aspx?ID=37         

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Cannot open the excel files in SharePoint 2010

 Cannot open the excel files in SharePoint 2010

 Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an error

"This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator"                                                                                          

In Previous Versions of SharePoint, what users do, They contact SP admins and ask them to add library to trusted file location (as error says) but in SP 2010 it's not the case 

Cause : By default the files are designed to open in browser . So it is checking for trusted location   

Resolution :Follow the below steps to resolve the issue.

1.   Go to the Library
2.   On the top click on Library and go to Library settings .
3.   Under General settings you will find Advanced settings
4.   Over there you will find the option which by default is set to open in Browser
5.   You need to set it to Open in Client and there you go .
6.   Click OK and you are done

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.To create an Excel Services Application trusted location,contact your system administrator

"This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator"

Cause :By default the files are designed to open in browser. So it will check for trusted location   

solution :Follow the below steps.

1.    Go to the Library

2.    On the top click on Library and go to Library settings .

3.    Under General settings you will find Advanced settings

4.    Over there you will find the option which by default is set to open in Browser

5.    You need to set it to Open in Client and there you go .

6.    Click OK to apply the settings.

 Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!