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

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

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.

 

WorkArround:

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

 

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

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

 

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

 

Select "Allow the connection"

 

Select what you want.

 

Give a appropriate Name and Description

 

Restart your SQL Server

 

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



Leave a Comment
  • Please add 7 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Gokan Ozcifci edited Revision 9. Comment: Added Image, this wasn't working cause my website gokanozcifci.be is out

  • Ed Price - MSFT edited Revision 7. Comment: Title, tags

  • Gokan Ozcifci edited Revision 6. Comment: New title and edit content

  • Horizon_Net edited Revision 5. Comment: added language tags

  • Gokan Ozcifci edited Revision 4. Comment: Made some design changes

  • Ed Price - MSFT edited Original. Comment: Updated title per guidelines

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price - MSFT edited Original. Comment: Updated title per guidelines

  • Gokan Ozcifci edited Revision 4. Comment: Made some design changes

  • Horizon_Net edited Revision 5. Comment: added language tags

  • Gokan Ozcifci edited Revision 6. Comment: New title and edit content

  • Ed Price - MSFT edited Revision 7. Comment: Title, tags

  • The images aren't showing for me.

  • Gokan Ozcifci edited Revision 9. Comment: Added Image, this wasn't working cause my website gokanozcifci.be is out

Page 1 of 1 (7 items)