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?