SharePoint 2010: Server TCP Provider failed to listen on ['any' <ipv6> 1433]. TCP port is already in use

  • Article

Error

I installed a new SQL instance on my envirement but could not connect from my SharePoint Server to get any data. 

So I went to Event Viewer to check any information, and saw this error: 
Server TCP provider failed to listen on ['any' <ipv6> 1433]. Tcp port is already in use.

http://gknzcfc.net/style/TCP1.png

WorkArround

I went to SQL Server Configuration Manager and configured protocols .. I replaced everyTCP PORT 1433 port to 1500

http://gknzcfc.net/style/TCP2.png

 

Second step was to configure the Firewall to open a specific port.

So on Windows Firewall made a NEW INBOUD RULE and select PORT

http://gknzcfc.net/style/TCP3.png

 

Select TCP and give your port number, in my case 1500

http://gknzcfc.net/style/TCP4.png

 

Select "Allow the connection"

http://gknzcfc.net/style/TCP5.png

 

Select what you want.

http://gknzcfc.net/style/TCP6.png

 

Give a appropriate Name and Description

http://gknzcfc.net/style/TCP7.png

 

Restart your SQL Server

http://gknzcfc.net/style/TCP8.png

 

And made a new UDL test. And now your connetion will succeed.

http://gknzcfc.net/style/TCP9.png