What are the basic steps necessary to connect to a remote SQL Server
using Dial-up Networking?
I am able to access the remote server via modem to
- successfully login
- map network drives
- ping the server
- users who are connected locally to that server are able to connect to
the SQL Server.
- the Server Network Utility shows TCP/IP installed with port number
- the client PC's Client Network Utility shows TCP/IP installed with
port number 1433 and
Server Alias and Computer Name showing the name of the remote server.
When I try to connect to the server using Query Analyzer, I get the
message "Unable to connect to server \\NTSERVER1 [Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets]General network error. Check your network
If I type in the IP Address of the server in the Query Analyzer
connection dialog I get "Unable to connect to server 10.0.1.175
Server message 1326, Level 16, State 1 [Microsoft][ODBC SQL Server
Driver] client unable to establish connection.
The server is NT Server 4.0 SP5 W/ SQL 7.0 SP1 and the dialup client is
NT workstation 4.0 SP5.