I cannot connect remotely to my MS SQL with enterprise manager..... the ports are not filtered and I even tried to disable the firewall...
It says that the conenction was refused....
Any ideas?

Are you trying to connect to the Helm MSDE instance, or do you have another version of SQL Server installed on the server?

I am using MS-SQL 2000 on one port, and the HELM instance on another.
I tried everything to connect, but the connection is refused.

Supposing you already bought additional licenses (check this thread)(very very costly and annoying), you must check if you configurated mssql with "accept only trusted windows" connection, or "mssql user".

You need an additional CAL license for Windows (for remote connections), and check the number of permitted connections on mssql. Anything else, you are simply a pirate!

Regards,
Netino

Did you install MSSQL in mixed mode authentication?

Here's how you check, find your instance of MSSQL Server. It will be something like

HKEY_LOCAL_MACHINESoftwareMicrosoftMSSqlserverMSSqlServer
or
HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQLServer

right click on loginmode in the right pane and see if it a 1 (Windows Authentication) or 2 (Mixed Mode Authentication).

If it is Windows Authentication, you must switch it to Mixed by stopping the MSSQLSERVER and the SQLSERVERAgent, changing this value to 2, then restarting MSSQLSERVER and the SQLSERVERAgent .

It is set for Mixed Mode since I installed it.

okey dokey

You have created an alias in the client network utility with the server IP and checked dynamically determine port?

Do this both from a remote EM and local EM. That will determine if there is something between your location and the server.

If you need more detailed help, PM me.