First off, apologies in advance for any misuse of networking terminology - I'm definitely not a networking guy.
I'm renting an instance from Amazon's cloud and want to have it connect to my SQL Server Express 2008 server that's in my apartment (on Win7). Problem is, that server is behind Comcast's NAT - that is, its public IP Address (say 24.130.X.X) is not the same as its private IP Address (say 192.168.X.X), and my macbook has the exact same public IP Address as my data server.
When I'm on the Amazon cloud instance and try to connect to the SQL server in my apartment, if I just try to connect to 24.130.X.X (the public IP), it doesn't work. This doesn't surprise me since I'm not sure how it could tell whether I'm trying to connect to my macbook or my data server, for example.
My question is: is it possible for me to connect to my data server through Comcast's NAT, using some more specific IP address than the generic public one? Obviously since it's Comcast's NAT, I can't modify it or do port forwarding or something.
Just in case it comes up, yes I've gone through countless articles on configuring SQL Server Express 2008 for remote access and I've added exceptions to the firewall. Thanks in advance for your help and patience.