Introduction
This article explains how to configure an instance of the SQL Server Database Engine to listen on a particular fixed port by utilizing the SQL Server Configuration Manager. The default example of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are arranged for dynamic ports. This implies they select an accessible port when the SQL Server administration is begun. When you are interfacing with a named instance through a firewall, setup the Database Engine to listen on a particular port, so that the fitting port can be opened in the firewall. Here are given 5 different approaches to get resolution of 26 - A network-related error occurred in SQL Server. In my earlier, I have already explained how to find and delete duplicate values in SQL server.Error Description:
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) (Microsoft SQL Server, Error: -1)
Approach 1: We can run this query to view your TCP endpoints
SELECT name, protocol_desc, type_desc, state_desc, is_admin_endpoint, port, is_dynamic_port, ip_address FROM sys.tcp_endpoints
Approach 2: Here you can check which SQL port is running on your machine.
USE MASTER GO xp_readerrorlog 0, 1, N'Server is listening on' GO
Approach 3: Run below command to check applications listening on ports, try this command on command line:
netstat -ap TCP
Approach 4:
i) Open Immediate Window (Windows + R) on your machine.
ii) Next type %windir%\System32\cliconfg.
iii) Now a new window will open, left side will show disabled port and right side will show enabled port.
iv) Now Select TCP/IP disabled protocols and click on Enable button to add in enabled protocols list.
v) Now you will enabled TCP/IP protocols and click on properties, then finally you will see SQL Server port i.e. 1433
Approach 5:
- Start from open your SQL Server Configuration Manager
- Next click on "SQL Server Network Configuration" and click on "Protocols for Name".
- Now right click on TCP/IP, click on properties and make sure it is enabled.
- Presently Select "IP Addresses" Tab - and-Go to the last passage "IP All".
- Now enter SQL server port TCP/IP 1433
- Remove 0 (keep totally blank) from TCP Dynamic Ports property
- Now restart your SQL Server (Right click on SQL server Management Studio and click restart button).
Superb post bro...
ReplyDelete