SQL 2008 R2 error: SQL Network Interfaces error: 26

Question

SQL 2008 R2 error: SQL Network Interfaces error: 26 - Error Locating Server/Instance Specified 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 Interfaces error: 26 - Error Locating Server/Instance Specified) And Don't Show this Properties SQL Server Configuration Manager > SQL Server Services > In Right Side window show all the servers which may stop. If you are using SQLEXPRESS then  Right click on SQL Server(SQLEXPRESS) And Don't Show this Properties

Rafnas T P · Answer

if you wanted to use same system as your server then give your full system Name check your system property what is the computer name.

Puneet Kankar · Answer

check below links https://stackoverflow.com/questions/33893089/sql-network-interfaces-error-26-error-locating-server-instance-specified https://www.codeproject.com/Questions/310806/provider-SQL-Network-Interfaces-error-Error-Loc Open SQL Server Configuration Manager Now Click on SQL Server Network Configuration and Click on Protocols for Name Right Click on TCP/IP (make sure it is Enabled) Click on Properties Now Select IP Addresses Tab -and- Go to the last entry IP All Enter TCP Port 1433. Now Restart SQL Server .Name. using services.msc (winKey + r)

Rafnas T P · Answer

check server name properlly may be the server name is not correct

Thiruppathi R · Answer

See this URL https://blogs.msdn.microsoft.com/sql_protocols/2007/05/13/sql-network-interfaces-error-26-error-locating-serverinstance-specified/

SQL 2008 R2 error: SQL Network Interfaces, error: 26