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 Provider, error: 26 – Error Locating Server/ Instance Specified) (Microsoft SQL Server)
Cause 1: If SQLServer is not allowing remote connections.
Possible solution1:
1. Microsoft Management Studio, Right Click Database Server and go to properties
2. On Security Page, under Server Authentication select “SQL Server and Windows Authentication mode” and click OK
3. Restart SQLServer Service
In case of SQLServer 2005, follow below steps to enable remote connections
1. Click on Startup, go to Program files and Select Microsoft SQL Server 2005--> Configuration tools--> SQL Server Surface Area Configuration
2. Click on “Surface Area Configuration for Services and Connections --> SQL Server Browser--> Select “Automatic” for Startup type and Apply
Cause 2: TCP Port 1433 or UDP Port 1434 ports are not in Firewall exceptions
Possible solution2: Add exception to allow port TCP Port 1433 and UDP Port 1434 or Turn off Firewall rules
Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com
Posts
