Wednesday, March 20, 2013

LinkedIn is down today

When I try to access the LinkedIn today, it was down may be because of some issue or may be because of the maintenance activity.

The point I want to make it here is how they presented the error message as shown here:

This picture engages the user that they are working on issue. If you observe the picture you can even identify the error id as well :)

Monday, February 11, 2013

Installing & Configuring the Analysis Service in SharePoint Mode

Microsoft SQL Server PowerPivot extends SharePoint and Excel Services to add server side process for the PowerPivot workbooks published to SharePoint.

In this blog I am going to explain on how to install and configure Analysis Service in SharePoint Mode. First lets look at the software requirements:
  • SQL Server 2012 Service Pack1
  • SharePoint 2013 Enterprise Edition
  • PowerPivot add-in for SharePoint 2013
SQL Server PowerPivot for SharePoint is only available with SQL Server 2012 Service Pack-1. This can be installed on a server running SharePoint 2013 or even on a different server with no dependencies on SharePoint 2013.

I am going to add one more virtual server "VMServer20" to the existing SharePoint farm explained in my previous post "Configuring Office Web Apps 2013 with SharePoint 2013" as shown below:

Here are the basic steps for this installation & configurations:

1. Installing PowerPivot for SharePoint
2. Configuring the Analysis Service in SharePoint Mode
3. Installing PowerPivot on SharePoint Servers
4. Configure PowerPivot for SharePoint
5. Verifying with a Sample

Step-1: Installing PowerPivot for SharePoint:

Run SQL Server Setup on the Server where you want to install SQL Server PowerPivot for SharePoint, in my case it is VMServer21. Make sure that the server is added to the Domain and run the setup as an administrator and also make sure you logged in with the Setup Account:

Click on the New SQL Server stand-alone installation or add features to an existing installation

Click OK to continue (make sure all the supported rules are passed)

Provide the license key and Click Next to continue

Select the I accept the license terms and Click Next to continue

Click Next to Continue, in case of any warnings for Windows Firewall rule, you can fix it ever after installing. It also might vary based on which environment we are setting up this server (like DMZ).

Here is the important step for this installation, Select SQL Server PowerPivot for SharePoint and Click Next to proceed further.

In this step Optionally you can select Add SQL Server database relation service engine to this installation in case if you want add this server as a content database to the SharePoint farm.

Click Next to proceed. If required you can change the default directory path.

Click Next to Proceed further.

This is another important step in this installation, make sure that the powerpivot instance is available on the server as its mandatory to install only on named instance called "POWERPIVOT".

Click Next to proceed.

Click Next to Proceed.

Provide the domain account on which you want to run this service and Click Next to continue.

If you want to run the instance in Mixed Mode, provide the password for the SA account. Add the current user to the administrators list. Click Next to proceed.

Add the current user to the Administrators list and click Next to continue.

Click Next to proceed.

Click Next to Proceed.

Click Next to Proceed with the Installation.

With this we completed installing SQL Server PowerPivot for SharePoint.

Step-2: Configuring the Analysis Service in SharePoint Mode:

Configure the Excel Services Domain Account which is configured in the SharePoint as part of the Administrator in the Analysis Service. In order to add this account, Open Management Studio & connect to the Analysis Service (VMServer20\PowerPivot) -> Right Click and select properties and Add the account as shown below:

Step-3: Installing PowerPivot Add-In for SharePoint:

Download and install Powerpivot Add-In for SharePoint on all the Web Front End Servers as well as on App Servers. First start with installing on the Central Admin Server by running spPowerPivot.msi

Click Next to Continue.

Accept the License Terms and Click Next to Continue.

Click Next to Continue.

Click Install to initiate the installation.

Click Finish to complete the installation of PowerPivot Add-In for SharePoint.

Step-4: Configuring PowePivot for SharePoint

Open the PowerPivot for SharePoint 2013 Configuration tool in Central Admin Server as shown below:

Select Configure or Repair Powerpivot and Click OK to continue.

Provide the Default Domain Account, Content Database and PowerPivot database instance. Click on Validate to verify the configurations.

Click Run to provision the PowerPivot Service Application in the Farm.

With this we completed the configurations. Now we are ready to verify the same.
Now you can install the PowerPivot Add-In on all the other servers in the SharePoint farm.

Step-5: Verifying the Configurations

You can verify the configurations by Browsing to the Central Admin -> Manage Service Applications, You will see new Service Application called "Default PowerPivot Service Application" as shown in the following image:

Click on Excel Service and Select Manage from the ribbon.

Select Data Model Settings and you will see the PowerPivot instance of the Analysis Service.
Now lets open a sample excel workbook which is published to excel and try slicing the data.

With this we completed Installing, Configuring & Validating the SQL Server PowerPivot for SharePoint 2013.

Let me know your comments!!!

Thursday, January 24, 2013

Configuring Office Web Apps 2013 with SharePoint 2013

Here is my first blog in this year which I want to provide my hands on experience on how to configure Office Web Apps 2013 with SharePoint 2013 on Premises.

As we know that the Office Web Apps is now a separate product which allows users to view and optionally update office documents using a supported browsers. This not only works on desktop but also supported on mobile devices likes Windows Phones, iPhone and iPads too.

Office Web Apps 2013 comes with improved features and architecture which allows Office Web Apps to provide view capability for Exchange Server 2013 & Lync 2013. In blog post I will explain how we can install & configure the same for SharePoint 2013 on premises environment especially for the developers & SharePoint Administrators.

Here is how my existing SharePoint Farm which I use for development purpose and to simulate the QA/Prod environments:

In this blog I am assuming that the SharePoint farm is available to configure Office Web Apps (OWA). Here are the Simple 9 steps to configure the same:

Step-1: Preparing Server with Prerequisite Software

There are certain prerequisites for installing OWA and make sure the following prerequisites are installed on the server in our case it is VMServer21.

Step-2: Preparing Server with Prerequisite Configurations

There are certain features to be enabled for OWA installtion, we can enable that using following PowerShell script in the Windows PowerShell Command prompt. Make sure that the you are opening PowerShell prompt as administrator.

For Windows Server 2008 R2

Import the necessary module before by executing the following command:

Import-Module ServerManager

And then run the following command:

Add-WindowsFeature Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,

For Windows Server 2012

Run the following command:

Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,

After completion of executing the command restart the machine.

Step-3: Installing Office Web Apps Server

Download Office Web App Server from Microsoft Download Center and you can extract the files from the image using any image extract softwares like MagicISO.

After extracting the files from the image, run Setup.exe.

Step-4: Installing Language Packs for Office Web Apps Server

Download necessary language packs from the Microsoft Download Center and run the WebAppsServerLP_en-us_x64.exe

Step-5: Creating Office Web Apps Server Farm

Planning Office Web Apps Server farm is very important based on how we are going to leverage, based on that we have to plan for load balancer, Number of servers, Certificates and so on. In this blog post we are going to see how to configure single server farm on HTTP.

Before configuring make sure that there no applications running on a default port as it is going to be used by OWA. To create a OWA single server farm execute the following PowerShell Command:

New-OfficeWebAppsFarm –InternalURL "http://vmserver21" –AllowHttp -EditingEnabled

Lets see what are these parameters means:

-InternalURL - is the name of the server that runs OWA, in our example it is vmserver21. In case of multiple server farm we have to provide the DNS configured in load balancer.

-AllowHttp - configures the farm to support HTTP.

-EditingEnabled - enables editing in office web apps especially when you want to edit the document from SharePoint.

Here is how it looks after running the command:

Step-6: Verifying Office Web Apps Server Farm

You can validate whether Office Web Apps Server Farm by executing the following URL:


and gives an xml output as shown below:

In case if you are not getting XML output as shown in the above picture and getting error related registering httpmodules, execute the following command to register ASP.Net framework 4.0 with IIS:

%systemroot%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -iru 

Following image shows the output of this command:

After completing this command don't forget to reset IIS by executing IISRESET command in the same command prompt.

With these steps we completed installing OWA 2013 and Configuring it successfully. Now lets see how to configure SharePoint to use OWA.

Step-7: Configuring SharePoint 2013 to use OWA

We can configure SharePoint to use OWA by executing following Powershell Commandlet in Central Admin Server:

New-SPWOPIBinding -ServerName -AllowHTTP

Following screenshot shows the output of the commandlet:

Office Web Apps Server uses the concept of zones to determine which URL (internal or external) and which protocol (HTTP or HTTPS) to use when it communicates with the host, which in this case isSharePoint 2013. By default, SharePoint Server 2013 uses the internal-https zone. Verify that this is the current zone by running the following command:


In case if the output shows other than internal-http as we are using http protocol to communicate with OWA Server, you can set it by executing the following commandlet:

Set-SPWOPIZone  "internal-http"

Step-8: Configuring SharePoint 2013 Security Token Service to allow OAuth Over HTTP protocol

To use Office Web Apps withSharePoint 2013 over HTTP in a test environment, you must set AllowOAuthOverHttp to True, Otherwise Office Web Apps will not work.

$config = (Get-SPSecurityTokenServiceConfig)
$config.AllowOAuthOverHttp = $true
 The output of these commands is as shown below:

Step-9:  Final Step is Testing OWA is Working as expected

The final step is to test the OWA is working as expected, in order to do this step open the existing site in a browser and upload couple of office documents and following image demonstrates the same:

You can test by clicking on the document which opens within the browser and don't forget to look at the URL as the SharePoint uses WOPI interface (/_layouts/15/WopiFrame.aspx) to render the document

With this we successfully completed the configuration of SharePoint 2013 to Use Office Web Apps.