Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A Remote Blob Store connection fails when hosted in an availability group

A Remote Blob Store connection fails when hosted in an availability group

View products that this article applies to.

Symptoms

Consider the following scenario:
  • In a deployment of Microsoft SharePoint Server, you host SharePoint databases in a Microsoft SQL Server AlwaysOn availability group for high availability.
  • You define an availability group listener in a multisubnet environment.
  • You configure SharePoint to use the listener to connect to SQL Server.
  • You install and deploy Remote Blob Store (RBS) to store and access binary large objects by using SharePoint.
In this scenario, connection time-outs cause the SharePoint application to intermittently fail to connect when the application tries to access the RBS data. Specifically, this problem may be caused by a failover of the AlwaysOn availability group.

↑ Back to the top

Cause

The connection time-outs occur because RBS does not implement the MultiSubnetFailover=True connection string when it connects to SQL Server.

↑ Back to the top

Resolution

To resolve this problem, add support for MultiSubnetFailover by updating the connection string that RBS uses to connect to the Filestream blob store. Assuming your RBS database is named "WSS_Content," this connection string is stored in the WSS_Content.mssqlrbs.rbs_blob_stores data column.

Important In this process, we recommend that you perform a SELECT INTO operation into a new table from [WSS_Content].[mssqlrbs] in order to back up the initial blob_storge_location data value before you perform the update.

Also, make sure that this connection string sets the Data Source parameter to the availability group listener.

For example, the UPDATE statement could resemble the following: 

UPDATE [WSS_Content].[mssqlrbs].[rbs_blob_stores]

SET blob_store_location='Data Source=ag_listen;Initial Catalog=WSS_Content;Integrated Security=True;MultiSubnetFailover=True;Application Name="Remote Blob Storage FILESTREAM Provider"'
Note In this example statement, WSS_Content represents the actual RBS database and ag_listen represents the actual availability group listener. Also, make sure that you add the MultiSubnetFailover=True parameter to the connection string, as shown.

↑ Back to the top

More Information

For more information about how to implement SharePoint together with SQL Server AlwaysOn availability groups, see the following Microsoft TechNet topic:

Configure SQL Server 2012 AlwaysOn Availability Groups for SharePoint 2013

↑ Back to the top

Keywords: kbexpertiseadvanced, kbsurveynew, kbfix, kb

↑ Back to the top

Article Info
Article ID : 2956899
Revision : 1
Created on : 1/7/2017
Published on : 5/2/2014
Exists online : False
Views : 405