Adding SSAS (SQL Server Analysis Service) to an Existing Cluster

I have already installed SQL Server in failover cluster. Which consists of two nodes.

I have requirements which need SSAS (SQL Server Analysis Service) and SSRS (SQL Server Reporting Service)

After many tries, I failed!!!

After some search… I found the following line in SQL Server 2008 R2 White Paper

Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server.

In shourcut: you can’t install  SSAS or SSRS on an existing cluster.


Adding third or new node (server) to the cluster and install on this node the SSAS and SSRS. (this solution is my suggestion)


Calculations in SharePoint Designer 2010 Workflow (Arithmetic)

How to make calculations in SharePoint Designer 2010 Workflow.

Add step (optional)


From Action menu click on Do Calculation




Publish InfoPath Form Issue – InfoPath failed to publish

When you trying to publish an InfoPath form to document library for the first time it successes.

But try again; you will get the following error message

“InfoPath failed to publish because the default content type in the document library is not based on the Form content type.”


  1. Go to Site Actions >> Site Settings >> Manage site features
  2. Activate the feature “Team Collaboration Lists”

  3. In InfoPath form; File >> Publish >> SharePoint Server

  4. Publish the form again to a new document library instead of the old one because the old one was create of template Document Library

    And the correct on should be Form Library

OData in SharePoint 2013 – Lists and Items

I will explain below the most common GET operations which most of developer may need them while query SharePoint 2013 lists and list items using REST.

  • Get all lists in web

  • Get all list by title

  • Get all items in specific list
    • Request: http://<server>/_api /web1/web2/lists/GetByTitle(‘myList’)/items
    • Result: the below screen shows one item Meta Data in the response

  • Get list item by item ID
    • Request: http://<server>/_api /web1/web2/lists/GetByTitle(‘myList’)/items/GetItemById(4)
    • Result:

  • Return items with specific fields
    • Request: http://<server>/_api /web1/web2/lists/GetByTitle(‘myList’)/items?$select=Title,Age
    • Result:

  • Order items in the query


For more information:

My Session in RSUG Event on 8 Nov 2012

I just finished my session in RSUG 8 Nov , I was talked about SharePoint 2013 from basic to new feature with SharePoint 2010

here is my online session

and here my downloadable session Download 

below are photos taken during the event.


Thanks for all attendance…