SQL Server remote access is disabled (SharePoint 2010 Products)


Applies to: SharePoint Server 2010, SharePoint Foundation 2010

Alert Name:   SQL Server remote access is disabled

Event ID:   None

Summary:   Microsoft SharePoint 2010 Products uses Microsoft SQL Server 2008 Express to store data, to which remote access is disabled by default. Depending on your farm setup, there is the possibility that a remote computer will need access to the SQL Server 2008 Express database.

Symptoms:   Connecting to SQL Server 2008 Express from a remote server fails.

Cause:   Remote access is disabled

Resolution:   Enable remote access

  1. Enable remote access. For more information, see How to configure SQL Server 2005 to allow remote connections (https://support.microsoft.com/kb/914277).