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.
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.
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
The images aren't showing for me.