SQL server issue and solution
Error summary:
The users might often see the error “SQL Network Interfaces, error:26- Error Locating server/Instance Specified”
This error message may prompt while connecting to SQL Server.
Reason for error:
- SQL Server service may not be running.
- TCP/IP may not be enabled in SQL Server Configuration.
- Remote Connections may not be enabled.
RESOLUTION: The following are the steps to resolve this error
1.First check the SQL Server service is running or not:
Go to All Programs–> Microsoft SQL Server–>SQL Server configuration Manager–>SQL Server Services and check if the SQL Server Services and check if the SQL Server service is “Running”.
If the SQL server service is “Stopped” then right click on the SQL server and click Start.
The issue will be solved. If still getting the error, then check ‘TCP/IP’ in SQL Server Configuration.
2.Check TCP/IP in SQL Server Configuration:
Go to All Programs –> Microsoft SQL Server –>SQL Server Configuration Manager–>SQL Server Network Configuration–> Protocols for the specific SQL Server name
Check if the TCP/IP is ‘Disabled’ then right click on the TCP/IP and click Enable.
The issue has been resolved. If still getting the same error, then Enable Remote Connection.
3.Check the Remote Connection enabled or not:
Go to right click on the SQL Server instance and select Properties Go to ‘Connections’ and “Allow Remote Connections to this Server” if it is not allowed previously.
The issue will be solved.
