Yammer Integration

Integration Of Yammer with SharePoint 2010 Server.

In this post, we are going to see how to integrate the yammer with SharePoint 2010 step by step

• Extract the file provided by Yammer to a directory on a SharePoint web-server (for example C:\YammerSP).
• Browse to the folder where you extracted the zip above.
•  Browse to the “Installer” folder.
• Run the Setup application.
• You must complete each step in the wizard to successfully deploy the Yammer Web Part.
  
                          
  
  
  When finished, each of these items should have a green check. For any that remain orange, Need to troubleshoot that and make sure all are in Green.
  
  
  
   
  
  
  
  
  Both solutions must be installed for Yammer to operate.
    
  
  
  
   Validation Checks completed successfully then select next.
  
  
  
  
  Select the list of web application to which yammer feature require to activate. For first time choose Central Admin as well with user based web application.
  
  
  
  
  will get the below screen once yammer feature installed.
   
  
  
  
  Like Yammer feature, Asset solution have its own validation. Once it passed asset solution also get installed.
  
  
   
   

Finally we got Setup Completed Screen.

    

                                 

• Once the feature installed, Login to SharePoint central Admin.
• Select Application Management -> Manage Web Applications.
• In right side corner in top of the ribbon, can see the yammer icon.
• Select it and configure it as per the account details which is actively available in Yammer.

One Good News to you, From 2013 Onwards don't worry about the above steps. The Microsoft yammer feature has been inbuilt with SharePoint 2013.

PowerPivot for SharePoint 2013

Installation and Configuration of PowerPivot integration with SharePoint 2013 in Central Administration

Not able to add the SharePoint mode of Analysis services in existing Instance of SQL server. Due to this, require to rerun the MSSQL Server 2012 with SP1 setup to add the feature.


Prerequisites

• You must be a local administrator to run SQL Server Setup.

• SharePoint Server 2013 enterprise edition is required for PowerPivot for SharePoint.

• The PowerPivot instance name must be available. You cannot have an existing PowerPivot-named instance on the computer on which you are installing Analysis Services in SharePoint mode.

Install PowerPivot for SharePoint

Require to run the MSSQL server 2012 setup to add the features of 'Analysis Services in SharePoint'.

• Double click the setup.exe file of SQL server 2012.
• Choose the option "New SQL Server stand-alone installation or add features to an existing installation" .
• As usual of Microsoft product installation, give next/ok till "Setup Role" page in SQL server installation process.
•  In Setup Role page need to select the following option ''SQL Server PowerPivot for SharePoint"

                  

• If dedicated Database engine available in the environment to sharepoint, then no need to choose 'Add SQL Server Database  Relational Engine Services to this Installation'
•  Instance name is 'ServerName\POWERPIVOT' by default, can't change this, Need to review the same will update if i get the solution related to this.
• On the 'Analysis Configuration page', add the service account which used to configure the SharePoint or excel services in SharePoint.
• Once the installation completed fully just restart the server once.
• After the server restart, To verify the installation Open Microsoft SQL server Management Studio, Connect Analysis service, provide servername\powerpivot. If the you can connect then the installation was successful and ensure service account have access to this instance.

Configure Excel Services for Analysis Services integration

• Open Manage service Application page in SharePoint Central Administration. (SharePoint Central Admin -> Application Management -> Manage Service Applications).
• Select the Excel Service Application and choose manage in the top ribbon.
• On Manage excel service application page select 'Data Model Settings'.
• Click Add Server, Provide servername/POWERPIVOT.
• Once the PowerPivot instance added, restart the Excel services in SharePoint central admin in the mange services in server option.

If SQL Server 2012 Analysis Services are not installed in SharePoint Mode, Then required to follow the below steps.

After installed the SharePoint for POWERPIVOT add on you will get a POWERPIVOT CONFIGURATION TOOL and POWERPIVOT configuration for SHAREPOINT 2013.
 
Go to START -> Select POWERPIVOT Configuration for Sharepoint 2013, (In windows Server 2012).

Choose the Configure or Repair PowerPivot for SharePoint on First time configuration.
 

  

This window will show the list of Solution and feature which going to deploy to the central administration and web application.

Choose the validation option in this window.

Once the validation done, All the features and solutions are flagged with Green color if the flag in red color those won't install and deploy.

After validate once done just run the setup.

 

 Once again you need to confirm the same by choosing the Yes in the below window.

 Once the installation completed without error you will get the window pop up.

Consolidation report page will be appear. 

After this configuration, Just go to the web application and add the PowerPivot gallery. Enjoy the PowerPivot in SharePoint from Analysis services.

 


  

Cannot Convert Type

Cannot convert type ‘Microsoft.SharePoint.WebControls.DelegateControl’ to ‘System.Web.UI.IAttributeAccessor’

This error mostly happens when you trying to edit the master page of site in SharePoint.

To fix it

• Open the master page in notepad
• You’ll see a big chunk of html code that is commented out.
• Mostly this will be at the end of the page after </html> tag.
• Delete that chunk of data. The master page will work properly again.

Now check your page in browser which is error free.