KB313758: The Host Name is used as the Port Number when creating a SQL Server DSN in MicroStrategy Connectivity Wizard 10.2 - 10.5
![A Programmer's Day: Host, IP Address, and Port Number In Computer Networking, Socket Programing, and Distributed Applications A Programmer's Day: Host, IP Address, and Port Number In Computer Networking, Socket Programing, and Distributed Applications](https://2.bp.blogspot.com/-nw1guSvWmGM/XEjORHYceOI/AAAAAAAAF2I/Bw8aMuv2mEw9p5_dLb6zE828NUU-USWUQCLcBGAs/s1600/host-tcpip-udp-socket-programming-computer-networking.png)
A Programmer's Day: Host, IP Address, and Port Number In Computer Networking, Socket Programing, and Distributed Applications
![How to solve SQLServerException: The TCP IP connection to the host XXX, port 1433 has failed - Product Knowledge Base - Product Knowledge Base How to solve SQLServerException: The TCP IP connection to the host XXX, port 1433 has failed - Product Knowledge Base - Product Knowledge Base](https://kb.sos-berlin.com/download/attachments/17499564/image2017-4-13%2015%3A52%3A32.png?version=1&modificationDate=1492098890000&api=v2)