>>>>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.
It isn't a license isssue as this is a per processor license. I can't see it as a resource issue. We're only connecting less than 10 people right now. This is a new server that we're attempting to get up and running.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer