SQL Server remote access is disabled (SharePoint 2010 Products)
Published: May 12, 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 (http://support.microsoft.com/kb/914277).