in the Console , SQL Server Configuration Manager
I get error 10048 when start sql service
and this in event history:
The SQL server service terminated with server-specific error. Only one usage of each socket (protcol/network address/port) is normall permitted. Any idea howto fix this ? Port set is the default 1433... If this is turned off, which is default of course, SQL service starts like a champ. I have done this config many times on other servers with no problem.
Figured it out. Right clicking the TCP/IP option there is an option to set 'Listeners' to all. Which is default, I changed this 'no', and it started so something must be up with my interfaces...
Sounds like there's something else already running on TCP port 1433. Stop the SQL Server. Then from a command prompt run
netstat -a -b
This will show you all the TCP ports which are in use and the name of the application which is using it. Find the application which is using TCP port 1433 and change that application to use a different port number.
I found this problem when trying to start my MSSQL Service.
At first, I changed listeners all from yes to no (as suggested in the accepted answer by @ebel). However, this way I was not able to connect to the server.
As @mrdenny suggests I identified the application using that port. In my case it was another instance of MSSQL Server running in a docker container.
Take also a look at this post for identifying the error logs of MSSQL Server and other applications running in that pot: https://blog.sqlauthority.com/2017/01/07/sql-server-unable-start-sql-service-server-tcp-provider-failed-listen-1433-tcp-port-already-use/
Procedure I used to fix this problem:
Open Sql Server Configuration Manager
Click SQL Server Network Configuration / Protocols for SQLEXPRESS
Right click on TCP/IP and go to Properties and then IP Addresses
Locate IP4 and in the IP Address put “127.0.0.1”
Find IPAll and in TCP Port put “1433”
And lastly, start the SQL Server service (SQLEXPRESS)
