In this blog post, let’s learn about the error message “26022 – Server is listening on [ %s <%s> %d].” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
26022 – Server is listening on [ %s <%s> %d].
Reason for the Error
SQL Server Error Msg 26022 occurs when SQL Server is unable to listen to the specified IP address or port. The error message typically looks like this: “Server is listening on [ %s <%s> %d]”.
Here’s what each part of the error message means:
– %s represents the IP address that SQL Server is trying to listen to.
– <%s> represents the IP address type, which can be either IPv4 or IPv6.
– %d represents the port number that SQL Server is trying to listen on.
The error message can occur for a few reasons. One possible reason is that SQL Server is already listening on the specified IP address and port, and another application is trying to use the same IP address and port. Another possible reason is that the IP address or port is not valid.
Solution
To resolve this error, there are a few steps you can take:
- Verify that the IP address and port number are correct. Make sure that the IP address is valid and that the port number is not already in use by another application.
- Check to see if another application is using the same IP address and port. You can do this by running the following command in the command prompt:
netstat -ano | findstr :<port_number>. This will show you which process is using the specified port number. If another application is using the same port number, you will need to stop that application before starting SQL Server. - Verify that the IP address and port number are not blocked by a firewall. Check your firewall settings to ensure that the IP address and port number are allowed.
- If you’re running SQL Server on a virtual machine, make sure that the virtual machine is configured correctly. The virtual machine should be set up to use the correct IP address and port number.
