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
- Enable remote access. For more information, see How to configure SQL Server 2005 to allow remote connections (https://support.microsoft.com/kb/914277).