How to install .Net Framework 3.5 on Windows Server 2012 R2

You may experiencing trouble installing .Net Framework 3.5 on Windows Server 2012 R2 using “Add Rules/Features”

If you’re trying to install SQL Server 2012, you may receiving the following error:

“Error while enabling windows feature: NetFx3”

You will face the same error […]

SharePoint 2010 Config wizard Failed : could not find stored procedure sp_dboption



Exception: System.Data.SqlClient.SqlException: Could not find stored procedure ‘sp_dboption’.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, […]

Enable External Users in Office 365 – Enterprise Account


You might have noticed the site collection feature to enable external user invite in office 365 Enterprise account. But after enabling the feature still you may not be able to invite users.

You need to login to Portal, and click on Manage under “SharePoint”

Click on Manage Site Collections


Click […]

Quick Tip: List View Threshold in SharePoint 2010

Most of us know that SharePoint has performance implications, when the list view has more 2000 items. SharePoint 2010 allows us to take control over the resource consumptions at Web Application Level. Resource Throttling would allow us to set the maximum limit per list view.


Central Administration -> (Application Management) Manage Web Applications


Learn to Leverage BI in SharePoint 2010 – Webinar

Here is my upcoming webinar in SharePoint 2010 Business Intelligence.


Time is Running Out! Register Today!

Turn towards a robust Business Intelligence Solution to empower your Organization

As a technology leader, you know in this challenging economic environment, getting access to the right information at the right time has […]

Service Pack1 for SharePoint 2010 Available

Microsoft Released the SP1 for SharePoint 2010 Products, Here is the links to download.

1. Service Pack 1 for SharePoint Foundation 2010

2. Service Pack 1 for SharePoint Foundation 2010 Language Pack (if applicable)

3. Service Pack 1 for SharePoint Server 2010

4. Service Pack 1 for SharePoint Server […]

Error while creating PowerPivot Library


Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’.


Power Pivot Library has some special views such as gallery view, carousel view, etc. The default view for the library has the reference from the assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’, which is packaged in solution package “powerpivotwebapp.wsp“.


When PowerPivot addin deployed for SharePoint, […]

How to Turn on the Wizard for Score Card Designer

How to Turn On/Off the Wizard for Score Card Designer

To turn on the Wizard for Score Card in Dashboard designer, click on the Office Icon in top left corner

Click on the Designer Options button in the Menu.

Document ID in SharePoint 2010

Business problem

The sales person sending document to marketing team, meanwhile the sales team has done some content organization reshuffled the documents to subfolder and different document libraries. If someone tries to pullout the document using the URL, they wouldn’t be able to find it.

Overview of Document ID


Site Template ID in SharePoint 2010

I was working on creating my new codeplex tool for Site Governance to automate the process of creating the site based on the request.

The site will be provisioned programmatically using the object model in custom actions associated with SPD workflow. While building this action, I was trying to get the list of site templates […]