Sorry, I don't really have any more good suggestions. Some general ideas:
If you can connect server S from client C1 but not from client C2, then the
problem must be with client C2.
Can client C2 connect to any other SQL Server 2000 's? If not, perhaps there
is something wrong with the client network libraries on C2.
Using the Client Network Utility on C2, is TCP/IP enabled? Is it the first
protocol listed in the "Enabled protocols by order" list? (This presumes you
want to use TCP/IP.) Do the Client Network Utility values look the same as
client C1?
Firewall settings could be blocking you on either computer. For instance, on
server S, the IP Address of client C2 could be listed to be blocked. Or
client C2 could be in some untrusted sub-net. Unlikely I admit.
If the SQL Server on S1 is not listening on the default port (1433), then
you may need to adjust your connection string to some other port number.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Scott Lam" <ScottLam@discussions.microsoft.com> wrote in message
news:0E7E0DB9-67BD-4FD1-AB7B-23FB92BCE772@microsoft.com...
> 1. I can ping the server from Win2000 server
> 2. I tried using IPaddress,port as well .
>
> do you have anymore suggestions ?
>
> thanks
>
> "Scott Lam" wrote:
>
>> Hi,
>>
>> I have SQL Server 2000 installed on a computer running Windows 2000
>> Advanced
>> Server.
>> I'm using enterprise Manager from the Windows 2000 server to try to
>> connect
>> to another SQL Server 2000 installed on Windows 2003 server .
>> Whenever I tried to make the connection , I get the following error:
>> "SQL Server does not exist or access denied"
>>
>> I read a lot of issues coming up when SQL 2000 is installed on windows
>> 2003
>> server but i can't seem to find the solution.
>>
>> All the latest patches and services packs are installed on both servers
>> and
>> SQL servers.
>>
>> I checked the client network utility to make sure TCP/IP and Named pipes
>> are
>> enabled on both servers . Everything is identical . No aliases exists
>> either.
>>
>> I'm able to connect from my Windows XP workstation using Enterprise
>> Manager
>> to the SQL Server running in Windows 2003 server , but NOT from the
>> Windows
>> 2000 server.
>>
>> Also, i search the Microsoft Knowledge Base and I tried a lot of the
>> suggestions but nothing so far work.
>>
>> Anyone knows what is happening here ?
>> Any suggestion ?
>>
>> Thanks,
>> Hang
>>
