SQL server error 10048 occurs while starting the SQL server.
Here at Bobcares, we have seen several causes for this error while troubleshooting SQL issues as part of our Server Management Services for SQL database users, web hosts, and online service providers.
Today we’ll take a look at the cause for this error and how to fix it.
What causes SQL server error 10048 to occur?
Now let’s see what causes this error to occur. Port 1433 is a standard port number for SQL Server.
However, in some cases, the TCP port where the SQL server is listening is already used by another service or process.
These changes lead to the 10048 error. For instance, the error appears as:
How we resolve SQL server error 10048?
Now let’s dig into the solution part of this error. Here are some of the solutions that our Support Engineers follow to fix this error.
Find the process which is using that port and stop that process.
We run the below command in the command prompt to check the TCP ports which are in use. This also displays the name of the application which is using it.
netstat -a -bHere, we find the application which is using TCP port 1433 and change that application to use a different port number.
Change port of SQL Server to a port that is not used by any other process.
We follow the below steps to change the port of the SQL server.
1. Initially, we open the SQL Server Configuration Manager. For that, we click on Start >> Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager.
2. A Dropdown is available under the SQL Server 2005 Network Configuration and then we select the instance.
3. Here we right-click on TCP/IP and select Properties option.
4. Then we select the IP Addresses Tab to change to an open port.
5. Finally, we restart the SQL SERVER to fix this error.
[Need any further assistance in fixing SQL errors? – We’re available 24*7]
Conclusion
In short, SQL server error 10048 occurs when the TCP port where SQL server must run is used by other processes. Today, we saw how our Support Engineers fix this error.
Thanks for help mate. I found with “netstat -a -b”
Thanks for the feedback.We are glad to know that it worked for you ? .
Thank you , This helped me alot
Hi
I had same Error.
I have two SQL Server Instance.
checked SQL Server Configuration Manager then I understand defulte service was start , stop defulte service then I con start my sql service.
Hi,
Please contact our support team through live chat (click on the icon at right-bottom).
pra mim aparece esse erros
[ERROR] Can’t start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).
2024-10-12 20:24:56 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-10-12 20:24:56 0 [ERROR] Aborting
Hello,
Our experts are available to assist you with your concerns. We would be delighted to discuss this with you via our live chat feature. Simply click on the icon located in the bottom right corner to get started.