Error connecting to remote server from dial-up connection

[NathanGriffiths]

I have a dial up connection to our network from outside, when I connect I am able to run EM and QA (2000) from my client PC and connect to all available SQL Servers on the network, except one. When I try and register or connect to this server I get and error which says "Server does not exist or access is denied".

I have checked everything I can think of; using sp_configure on the server itself I have made sure 'remote login' is enabled and I have increased the 'remote login timeout' (as this is an older server so slower to respond). I am connecting using the the system administrator password so I think it is unlikely that access is denied, I have also checked that the correct network libraries are enabled in the Client and Server Network Utilities (TCP/IP and Named Pipes)

The server on the network is running NT4 with SQL Server 7, whilst my PC has Windows 2000 Server and SQL Server 2000 installed. I am using SQL Server Authentication with the system administrator login.

Anybody have any idea why this server alone can't be accessed from this dial-up connection to the network?

thanks,

Nathan Griffiths

 

[Zachary]

Check your MDAC version on the Win2k...

 

[NathanGriffiths]

Having checked, the older NT4 server is using MDAC 2.1 whereas the W2K server has 2.6 installed. Is this causing the problem and if so will upgrading the older server to 2.6 solve it?

thanks

Nathan

 

[tlbroadbent]

Open the Network Client Utility on the client and set up an alias for the problem server. If the Alias already exists, verify that the properties are correct. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.