This is a very common problem after you do a new install of SQL Server on a server. The moment you try to access it over the network, following error pops up:
"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: SQL Network Inrerfaces, error:26 - Error Locating Server/Insatance Specified)(Microsoft SQL Server)"
In SQL 2003, there used to be surface area configuration manager that you could use to enable network access to your SQL server. In SQL Server 2008, the interface has been changed a little bit. There is no surface area configuration manager per se. Here is the procedure you will follow in SQL 2008.
- From start menu of SQL Server 2008, run SQL Server Configuration Manager
- From left side view of SQL Server Configuration Manager, expand SQL Server Network Configuration
- In the right view, you will find list of protocols for SQL Server. By default only Shared Memory is enabled. Others are disabled. Enable the other protocols to get your SQL server to accept connections over the network.