Remote Dial in SQL Server

xiaoxiao2021-03-06  43

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

转载请注明原文地址:https://www.9cbs.com/read-78622.html

New Post(0)