If you get the following error message in SQL Management studio while accessing your SharePoint windows internal database, follow-up the solution steps
An error occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings, SQL Server does not allow remote
connections.
connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings, SQL Server does not allow remote
connections.
Solution steps:
1. open the SQL server configuration manager and right click the “ protocols for Microsoft##SSEE” under SQL server Network Configuration, Select properties then Change the “Hide Instance” status NO and click ok to close.
2. Confirmed the TCP Protocol is enabled and restart the SQL service instance.
3. Open the SQL server surface Area configuration, Click Surface configuration for Services and Connections and confirmed remote connection status to using TCP/IP protocols under the MICROSOFT##SSEE Instance.
4. Restart the Microsoft##SSEE instance service and now you can successfully access your SharePoint Database Instance.
