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 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”

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”

Enable Anonymous access for a SharePoint 2010 Site

If you want to publish your site that created by Sharepoint 2010 it is a good solution to allow anonymous access to it.

Let me show how I am doing: (later on I will attach figures too)

1. Open the Central Administration page and Application Management

2. Choose the Manage Web Application

3. Highlight your portal and select the Web Application tab on the ribbon above

4. Choose the Authentication Providers icon

5. On the pop-up window click the Default value

6. At the Anonymous Access option enable the anonymous access and press ok

7. On the ribbon above choose the Anonymous Policy (be sure whether your selection is still active)

8. Be sure that in All Zone the AnonymousUser Policy set to None – No Policy (Save It.)

9. Open your site and choose the Site Settings then choose the Site Permissions

10. Under the Permission Tools choose Anonymous Access icon

11. Check that Anonymous User Can Access: Entire Web Site radio button is selected (if do so, click ok)

12. Check whether you can see the anonymous user as permitted user to the site.

That’s all!

What services should be monitored in case of IIS?

Generally speaking monitoring process is very important in case of business critical applications.  A casual Sharepoint operation keeps on eye on the application’s services. Usually operation process has a look at the Sharepoint services. At some cases an IIS service failure is in the background when a Sharepoint service can not be reached or contacted. Usually operations forget about the IIS service monitoring. In case of a Sharepoint services can not be reached the operations team start the “debug” process at Sharepoint level then dig down to the IIS service level. It could be very annoying after spending one hour with log-analyzing it turns out that the root cause was an IIS service malfunction.

Continue reading “What services should be monitored in case of IIS?”

Your client does not support opening this list with Windows Explorer error

The dreaded Your client does not support opening this list with Windows Explorer error. I have seen a couple of times eventually discovering new causes of this error message. But the Internet is a good source solving this, after doing a couple of cross tests and research.

Basically you get this on your client when you try to open a document library with explorer (Open with explorer button on the ribbon on the Library tab) and something went wrong.

Your client does not support opening this list with Windows Explorer
Your client does not support opening this list with Windows Explorer

Continue reading “Your client does not support opening this list with Windows Explorer error”