Victor,

I've got it to work using LogMeIn Hamachi

>>Is there anything I am missing? I can't access the data from the other PC.
>>1. enabled TCP/IP and named pipes
>>2. set dynamic ports to blank and set a TCP port number
>>3. Added an exception for this port number in Windows firewall
>
>If you're trying to do this over the internet and your sql server is behind a router you also need to make sure:
>a) you have the right IP address. I see there has been some talk about that already - what kind of router do you have? Many routers come setting for dyndns or some other similar service.
>b) also on your router be sure you forward the ports you want to use to the ip address of the sql server machine. (the internal ip address of the sql machine of course - the ip assigned to it by your router).
>
>
>
>>I think you need a static IP which is also public. The static IP is necessary so the client application can lookup the IP address, and it must be reachable by the remote terminal. At least here in Aruba my router does have a "public" IP address, but the provider (or whatever is responsible) does not forward IP lookups to this IP address, so it's not reachable. It is also not static so it changes once in a while (usually when the router gets restarted). In the Netherlands for instance every internet client has a static IP address automatically, we can only dream of this, although it should be something simple for the provider to setup.
>>
>>The problem with no-ip (and probably other dns lookup services) is that they usually aim at making port 80 available, I haven't tried a lot, but I was not able to use no-ip to forward the port of the SQL server.
>>
>>With Hamachi on the other side it was very easy to setup (I did that once with a MySQL database, a few years ago), and it seems to be a free service for 10 terminals.
>>
>>>Thanks. Is it a static IP that is needed and that you are referring to as Public? Or are they two completely separate things?
>>>
>>>I have heard of using dyndns to create a free static ip.
>>>
>>>>It looks like Hamachi is free for up to 10 computers, but I did not read the entire FAQ carefully.
>>>>
>>>>
>>>>>I think that's pretty much the same here in the Caribbean, to get a public IP address is a pain and they charge a lot of money for that.
>>>>>
>>>>>Unfortunately, Hamachi does not seem to be free anymore.
>>>>>
>>>>>>OK, tried that and all 4 pings timed out, so I guess it's not public so I'll have to go with hamachi or something similar.
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>>Check http://whatismyipaddress.com/ and see if you can ping this IP from the remote computer.
>>>>>>>
>>>>>>>>Thanks, how do I determine if I have a public IP?
>>>>>>>>
>>>>>>>>I'll look into Hamachi as well.
>>>>>>>>
>>>>>>>>>That would only work if you have a public IP, and then you have to set port forwarding at the router.
>>>>>>>>>
>>>>>>>>>If you don't have a public IP address, a workaround would be to create a network using Hamachi from LogMeIn, I did that once and it was pretty easy to setup, and it's free if I remember correctly.
>>>>>>>>>
>>>>>>>>>>I believe that I have that configured as I am able to connect to the database from a different PC on the local network.
>>>>>>>>>>
>>>>>>>>>>I understand that I need to know the IP address of the database server, how would I determine that? This is what I would need to use in my connection string from the PC outside the LAN.
>>>>>>>>>>
>>>>>>>>>>>In SQL Server Management Studio, did you check "Allow remote connections" in the server properties?
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>>This is actually SQL Server Express 2012 .
>>>>>>>>>>>>
>>>>>>>>>>>>I have two PCs in a workgroup at a client. Both running Win 7 Home Premium. I have installed SQL Server Express 2012 on one and my system running on that PC is able to access it.
>>>>>>>>>>>>
>>>>>>>>>>>>I have:
>>>>>>>>>>>>
>>>>>>>>>>>>1. enabled TCP/IP and named pipes
>>>>>>>>>>>>2. set dynamic ports to blank and set a TCP port number
>>>>>>>>>>>>3. Added an exception for this port number in Windows firewall
>>>>>>>>>>>>
>>>>>>>>>>>>Is there anything I am missing? I can't access the data from the other PC.
>>>>>>>>>>>>
>>>>>>>>>>>>Update
>>>>>>>>>>>>
>>>>>>>>>>>>I found that I had changed the dynamic ports on IP2 (or was it IP4?) instead of IPALL. Once I did that I was able to connect.
>>>>>>>>>>>>
>>>>>>>>>>>>Now my next challenge is to allow a remote computer access to the database over the internet. Any suggestions of where to find instructions on how to do this?