I installed SQL Server 2008 on my new Windows 8 machine.
It had been installed on my Windows 7 machine and was running well for 3 years.
Here is the login error:
Cannot connect to ADMIN-PC1\MSSQLSERVER3.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.
How do I configure the server to accept remote connections?
Use the SQL Server Surface Area Configuration tool to allow SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.
Where do I find the SQL Server Surface Area Configuration tool ?