Colorful SharePoint table

So many time it’s useful to color a cell in a table on SharePoint pages. Out of the box we don’t have a solution to impress our visitors. Although we have the table with numbers inside but coloring the cells regarding to their value it’s more informative.

color_cell Continue reading “Colorful SharePoint table”

Advertisements

Drives used for SQL databases are running out of free space – Health Analyzer rule

Introduction

Health Analyzer does a great job warning you about possible problems on your platform, however it is extremely hard to stay on the good side (meaning it does not reward you with a red bar in Central Administration) without turning off a couple of rules.

I met with the Drives used for SQL databases are running out of free space message a few times and the other day reading the official documentation and feeling a bit confused and disappointed I decided to check out what this is about under the hood.

 

Continue reading “Drives used for SQL databases are running out of free space – Health Analyzer rule”

Sharepoint integrated reporting services with SQL Always on availability group

It happened once that i needed to provision a Sharepoint 2013 farm including MS SQL Server Reporting Services (SRSS). I had some issues – maybe you found this post ‘cos of that – which i would also share and give a hint on the solution.

Continue reading “Sharepoint integrated reporting services with SQL Always on availability group”

SharePoint 2013 Configuration Wizard fails with SQL Server max degree of parallelism error

Recently I tried to install SharePoint 2013 in my test environment based on the multiple servers for a three-tier farm scenario, where my SQL Server is on another machine and I got the following error during SharePoint 2013 Products Configuration Wizard:

Failed to create the configuration database

Exception: Microsoft.SharePoint.SPException: This SQL Server instance does not have the required “max degree of parallelism” setting of 1. Database provisioning operations will continue to fail if “max degree of parallelism” is not set 1 or the current account does not have permissions to change the setting.  See documentation for details on manually changing the setting.

Max degree of parallelism error
Max degree of parallelism error

I encountered this during farm creation on the first SharePoint server installation.

Continue reading “SharePoint 2013 Configuration Wizard fails with SQL Server max degree of parallelism error”

Mystery at Sharepoint Land

Although my site did not contain so much information and data Sharepoint told me that i reached the Storage Quota limit had been given to the site ->

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location.  Contact your administrator to change the quota limits for the Web site.

Of course the first step was to go to the “Recycle bin” to empty it. But after this procedure  i got the same error. Ohh yes, the secondary Recycle bin for the Site collection – with Site admin right i was able to delet all the contects of that bin also.

But still got this rude error message. What’s up here?

Continue reading “Mystery at Sharepoint Land”

Cannot connect to database master at sql server – Checklist

The problem

You get the following error during SharePoint 2013 Products Configuration Wizard on the Specify Configuration Database Settings page:

Cannot connect to database master at sql server <Servername>. The database might not exist, or the current user does not have permission to connect to it.

Cannot connect to database master at sql server
Cannot connect to database master at sql server

Checklist

Your first move should be the following: Try it again, but this time mark the time between you press Next > and when the error message pops up.

Based on this:

  • if its more than a few seconds, you have network connectivity issue or SQL server configuration problem (start from no 1)
  • if it pops up almost instantly, you have permission problems on the SQL server instance (See no. 10 and 9)

Continue reading “Cannot connect to database master at sql server – Checklist”

Cache service – define memory allocation

well, at last i got the cmdlets to adjust the memory allocation for the chache service at a given machine:


 $instanceName ="SPDistributedCacheService Name=AppFabricCachingService"
 $serviceInstance = Get-SPServiceInstance | ? {($_.service.tostring()) -eq $instanceName -and ($_.server.name) -eq $env:computername}
 $serviceInstance.Unprovision()
 Set-CacheHostConfig -Hostname <HostName> -cacheport 22233 -cachesize <Size in MB>
 $serviceInstance.Provision()</i>