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”

Advertisements

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”

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”

Create Active Directory users with Powershell

Scope

In my test environments I always have to create a couple of users to be able to do performance or functionality tests. Powershell really helps me with this task and I just want to archive this for later.

In the next few paragraphs I show you my method to create hundreds of test users on Windows Server 2012 with Powershell.

Continue reading “Create Active Directory users with Powershell”

Cannot install .NET Framework 3.5 features on Windows Server 2012

Symptom

On a default installation of Windows Server 2012 sometimes you experience problems with the .NET Framework 3.5 features while trying to enable it.

It fails if you try to install it using the Add Roles and Features Wizard, using Powershell or dism.

.NET Framework 3.5 features installation failure
.NET Framework 3.5 features installation failure

The same happens during an SQL Server installation with the following error message:

The following error has occurred:

Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling Windows feature: NetFx3 from Windows management tools and then run setup again.

Error while enabling Windows feature: NetFx3
Error while enabling Windows feature: NetFx3

Continue reading “Cannot install .NET Framework 3.5 features on Windows Server 2012”

Roles, features and the WinSxS folder in Windows Server 2012

Back in time when I had to install additional Windows Components on a 2003 Server the Windows Comopnents Wizard asked me to insert the install disk or point to a folder which contains the install files. In Windows Server 2008 this was changed and all files were copied to the C:\Windows\WinSxS folder so when I decided to install a feature or a role all files were already on the machine. Unfortunately these files cannot be removed but in Windows Server 2012 you have this option to save space, have smaller server footprint, and even satisfy your security officer: this is called features on demand.

Continue reading “Roles, features and the WinSxS folder in Windows Server 2012”

Recycle bin in SharePoint 2010

The recycle bin feature in SharePoint 2010 comes handy when any accidental deletion occurs, you can easily move the items back, even your users can restore files from there. It is important to understand that a document’s life does not end when a user deletes it and this can affect the storage behind your SharePoint farm. Therefore the recycle bins during in planning phase are often misunderstood and underestimated (especially when you size storage and set up quotas).

Continue reading “Recycle bin in SharePoint 2010”