Here's one for you MS gurus out there (please!!)

I have MSDE running on windows 2003 but cant seem to access it remotely. It's not a username/password issue because I can access it from the server no probs using the sa account.

I am thinking that its a problem with windows blocking port 1433/1434 but i'm not sure how to make sure they are open... I have looked at IPFilters, and think i've disabled them, but i'm not expert on this so I was wondering if one of you kind people would give me some advice (please, no "if you cant even do that then you shouldn't have a server" comments, they are not helpful).

Thanks in advance!

Jim.

Where is your server located at ? Certain datacenters are known for blocking the MSSQL ports

Have you placed MSDE into mixed mode by default it accepts trusted connections only, unless you are able to login to the domain that the MSDE server is part of, then you won't have a trusted connection. Edit the registry change LoginMode to 1 and restart MSDE.