Connecting to a remote SQL Server

I am trying to connect to a SQL Server that is located in my home office from
remote office location. I've tried to setup a connection using Enterprise
Mgr, but it is not working. Can someone provide the steps if any to help?
Thanks
Sonya,
Have you tried registering the server using the IP address?
HTH
Jerry
"Sonya" <Sonya@.discussions.microsoft.com> wrote in message
news:4AE2C68B-3B14-4A88-A38F-716276A824EC@.microsoft.com...
>I am trying to connect to a SQL Server that is located in my home office
>from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks
|||Yes but it didn't find it. I can ping it, I tried to see if registered my
laptop db svr but it didn't.
"Sonya" wrote:

> I am trying to connect to a SQL Server that is located in my home office from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks
|||Sonya wrote:[vbcol=seagreen]
> Yes but it didn't find it. I can ping it, I tried to see if registered my
> laptop db svr but it didn't.
> "Sonya" wrote:
You'll most likely have Firewalls in between the 2 servers, so you need
to make sure that these allow SQL Server communication. If both
servers/pc's are installed with default settings, it will be port 1433
that is used. You can check this fairly easy by doing a telnet command
to the server (in a cmd prompt type "telnet YourRemoteServerIpAdresse
1433"). If you get to a blank screen, you have contact to the server on
that port. If the port it blocked you'll get an error message after a
short while telling you that the host could not be reached (...I can't
remember the exact message...).
Regards
Steen