Does anyone know why I cannot connect to SQL2000 through a Dialup connection until I restart the
Example, I connect a remote W2KPro computer to a standalone W2KPro computer using a Direct dial
TCP/IP connection. Next I try to talk to SQL2K through this connection (with an ODBC driver or with
Enterprise Manager) but it just will not work. So I restart the SQL2K service and then like magic I
can now talk to SQL through the connection.
Note: This is not the case when I use SQL7, I can connect through the dialup with out having to
Does any one know why?? How can I connect to SQL2K through a Dialup with out having to restart
Same problem in the following scenario.
I have a portable (Windows98 Second Release + SQL2000 Personal Edition SP1) and a desktop PC (Windows 2000 SP2 + SQL2000 Standard Edition SP1). I connect these two PC’s with a direct cable connection.
I want to register the SQL server database from the portable at the Desktop PC. It will only work after stopping and starting the SQL Server at the portable.
When I break the connection and restart the connection I have to redo the starting and stopping of the SQL Server at the portable otherwise the registering of the SQL server will not work.
The following will happen :
A connection could not be established…
Reason : SQL Server does not exist or access denied.
Does somebody know a solution ?
With kindly regards