I'm trying to connect to an outside server that hosts SQL Server 2000. The guys there told me that all I need to do is download Enterprise Manager, and I can connect to my database that way, and even though it's a trial version, the Enterprise Manager would keep working. I also was under the impression that I didn't need the server running on my machine, all I need to connect is the Enterprise Manager. First I want to make sure these statements are correct.

I did what they said and connected fine and have been updating my database for over 2 months now. Yesterday two things happened. The host said that he had to reset user/pass, and I also deleted some things from my startup. Now I am getting the following error when I try to connect to my database in Enterprise Manager:

A connection could not be established to...
Reason: SQL server does not exist or access denied.
ConnectionOpen (Connect())..
Please verify SQL server is running and check your SQL server registration properties and try again.


Does anyone know why this error is coming up? Thanks.

Steve