Today, connect customers SQL Server server through MODEM, encounter a few questions, summarize:
1, you can ping, but you can't open the Enterprise Manager and Query Analyzer, Telnet 1433 is not available
A: Turn off firewalls and virus software, server SQL network protocol Add multi-protocol
2, the IP address is turned 169 after dialing into the input ...
A: Server Access Incoming connection setting fixed network segment
3, the local network card address is changed to 0.0.0.0 after dialing.
A: The local network card and the dial-in connection use the same IP address, set the server access to another network segment, and disable the local network card and then enable