connection error

Hello,
We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
All 3 servers are in same location.
SQL-1 and SQL-2 are in same domain, i.e. domain-a.
SQL-3 is another domain, i.e. domain-b.
SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
(We did not add SQL-1 and SQL-2 on 'Client Network Utility')
But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and port
1433.
Then we have the message 'SQL Server does not exist or access denied
connection open (Connect[])' during add SQL-3 from 'New SQL Server
Registration'.
SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
using RPC' is checked.
ThanksHi
This could be a firewall issue or you may be using dynamic ports (if this is
a named instance for example). Have you checked which port SQL3 is listening
on? Can you telnet on the given port to SQL3 from the other servers? Have yo
u
tried using IP addresses instead of DNS Names?
You may want to check out SQLPing at
http://www.sqlsecurity.com/Tools/Fr...65/Default.aspx
Also check the client protocols being used your service pack would indicate
TCP/IP should be first.
John
"Newbie" wrote:

> Hello,
> We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
> We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
> All 3 servers are in same location.
> SQL-1 and SQL-2 are in same domain, i.e. domain-a.
> SQL-3 is another domain, i.e. domain-b.
> SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
> (We did not add SQL-1 and SQL-2 on 'Client Network Utility')
> But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
> We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and po
rt
> 1433.
> Then we have the message 'SQL Server does not exist or access denied
> connection open (Connect[])' during add SQL-3 from 'New SQL Server
> Registration'.
> SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
> using RPC' is checked.
> Thanks