Tuesday, February 22, 2011

Name of SQL Server instance in Standalone installation of SharePoint 2010

If you have performed a Standalone installation of SharePoint 2010, you may know that SharePoint 2010 will automatically install SQL Server 2008 Express edition for you.

Given that it is installing SQL Server 2008 Express, you would figure that the name of the SQL Server instance would either be (local) or (local)\SQLExpress. But, if you attempt to enter either of these values in SQL Server Management Studio, you will get an error message stating that a connection should not be established.

This is because the actual instance name of the SQL Server 2008 Express edition that is installed by the Standalone installation of SharePoint 2001 is actually (local)\SHAREPOINT.

No comments:

Post a Comment