>>>>I am attempting to install a remote SQL Server into Enterprise Manager. This is SQL Server 2000 running on Windows 2000 Server. The client is SQL 2000 Ent. Manager, also running on W2K Server. I can see the remote server and browse directories. However, when I try to register the remote server, I get an error back "SQL Server does not exist or access denied". I'm trying to use the SA account. Any ideas on what the problem is?
>>>
>>>What is the network connectivity setup for both servers? If using TCPIP, is port 1433 open for both servers?
>>
>>Yes, TCPIP and 1433 on both. I rebooted the server this morning and everything worked...for a while. Now I have some people that can connect and others that can't.
>
>Then it sounds like a one of the following:
>
>1. License issue
>2. Resource issue - when you can't connect, how many open connections are there and how much memory is SQL Server taking
>
>Sorry IO couldn;t be more helpful.


Well, we got this solved. Turns out there were two servers with the same name on the network. The wrong server was found first and caused the problem. An entry in the hosts file fixed this. Not ideal, but it works now.