SharePoint – Back to basics - Quotas and locks in SharePoint

In SharePoint, as an administrator, I can control the storage limits for a site. Quota specifies the amount of data that stored in a site collection. Quota settings will send emails when quota limit is exceeded. We can change the quota settings in SharePoint central Administration...

Add File type extensions in SharePoint search

By Adding or Removing File type extensions from the list of file name extension in SharePoint search, Search index will include/exclude the properties from files that we have added or removed. To include a file type in search, we have to check that the file type will support for...

SharePoint Launch Pad web part issue in IE

I am not able to login the SharePoint site, even entering the correct credentials. By checking this some time, I have found that this is launch pad web part in SharePoint server. IE settings are not allowing third party cookies to the Login page. We can fix this issue by adjusting...

Set All Search boxes to use the search center in SharePoint 2013

In SharePoint Site search boxes will crawl the data from local sites. We can see “Expand your search” link that redirects the search center, whenever we configure the global search center in the application. We can configure the search boxes in site level and site collection level...

SharePoint User Profile Service Error – Cannot navigate to the requested page because the service is not running”

While working with user profile service in SharePoint, configuring new connection, I got an error saying that “Cannot navigate to the requested page because…” as shown in the image below. To fix this we need to start the user profile service in the services. But we need...

SharePoint - Back to Basics – Resource throttling Settings

Resource throttling is configuration for performance of lists and resource contention. Resource throttling allows SharePoint Admins to manage the heavy data in SharePoint lists. From SharePoint lists supports millions of items, to control the data like number of items to retrieve...

Sharing SQL Server Analysis Service connection using SharePoint 2013 Excel Services

In my previous post, I have explained sharing SQL Server Data source connections in SharePoint 2013. In this post we can use SQL Analysis service connection. We can create Analysis service connection as shown the steps below, In Excel, Data tab,  click on From Other Sources...

Sharing SQL Server Data source connection using SharePoint 2013 Excel Services

We can connect different data sources using excel services includes SharePoint list, access DB, Windows azure etc... All the data connections in excel will support in excel services. We can refresh the data in excel service reports and dashboards and also supports SQL server tables...

“External Data Refresh Failed An error occurred during an attempt to establish a connection to the external data source . The following connections failed to refresh:” error in SharePoint 2013 PowerPivot data refresh

While practicing with SharePoint Excel Services and Power Pivot office web apps, when refreshing the data I got an error saying that “External Data Refresh Failed……” By checking the error found a solution from TechNet blog. When using Office web apps in SharePoint 2013,...

JSLink in SharePoint 2013

JS link is a new WebPart property in SharePoint 2013. It allows us to create the client side rendering solutions in SharePoint 2013. We can format the data and functionality in the WebPart. We can edit the fields and format the data and functionality with in the WebPart using JSLink. We can override the title column using the JSLink. We can use the Javascript file. In SharePoint...

SharePoint 2013 PowerPivot manual refresh failed error "An error occurred during an attempt to establish a connection to the external data source… “

While working with SharePoint 2013 PowerPivot, I got an error "An error occurred during an attempt to establish a connection to the external data source… " as shown the image below, while refreshing all the connections. In logs I have found the error like, “Current Identity...

Service Account Application ID is not specified or has an invalid value error in SharePoint

In SharePoint the unattended Service Account Application ID setting will stores the application identifier in registered Secured Stored Service. Application ID will use the unattended service account credentials. If unattended service Account is single, Visio graphics service impersonates,...