When I launch SQL Serve Management Studio, I am receiving the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes, error: 40 Could not open a connection to SQL Server) (Microsoft SQL Server,Error: 2)
In SQL Server Configuration Manager:
The following services are running (none are stopped)
- SQL Server
- SQL Server Agent
- SQL Server Analysis Services
- SQL Server Browser
- SQL Server Integration Services
- SQL Server Reporting Services
The following protocols are enabled:
- Shared Memory
- Named Pipes
If I set the Connection Properties to Shared Memory, the provider in the error message changes from "Named Pipes" to "Shared Memory". A timeout occurs for TCP/IP.
This SQL Server instance has been working without fail since original installation.
No changes have been made to user accounts.
I was going to try a complete Uninstall / Re-install. Does anyone know of anything else I could try or check?