IP Address SQL Server

Asked May 02 '17 at 15:35

Active May 02 '17 at 16:03

Viewed 106 times

I work remotely and travel a lot for work. When I am at home, I have no problem accessing my instance of SQL Server hosted by my company on AWS. The SQL Server instance is currently configured to only accept connections from ONE IP address and as it changes I lose my connection. Whenever I travel I cannot access SQL Server and when I come home, sometimes my IP address changes and I also cannot access from home.

I am sure this is an issue others have had. Can anyone suggest a solution? Whether it is from the DB side or client side?

Thank you,

dave

edited May 02 '17 at 16:03

marc_s

732,580
175
1,330
1,459

asked May 02 '17 at 15:35

hansolo

1

Had a similar issue and used Private VPN with a Static IP ... nominal cost – John Cappelletti May 02 '17 at 15:38
Are you sure it's a SQL Server restriction? Some months ago I tried to restrict incoming connections by IP address and [learnt](https://dba.stackexchange.com/questions/143334/allow-remote-access-only-from-certain-ip-addresses) it isn't possible (you need a firewall for that). – Álvaro González May 02 '17 at 15:39
you cannot acces because your ip address changed or because the ip address of the server changed ? – GuidoG May 02 '17 at 15:42
@guidoG because my ip address keeps changing – hansolo May 02 '17 at 15:43
@JohnCappelletti what service did you use? the private VPN I have looked into assign IPs randomly – hansolo May 02 '17 at 15:44
1

I used vpnstaticip.com very satisifed. There are many out there even cheaper Just google "private vpn static ip" – John Cappelletti May 02 '17 at 15:46
1

Also used them for my daughter when she was in China --- as you may know, they have many restrictions – John Cappelletti May 02 '17 at 15:47
Than the solution mentioned by John Cappelletti should work – GuidoG May 02 '17 at 15:48
thank you guys. very helpful – hansolo May 02 '17 at 15:49
just to come full circle - i signed up for PureVPN with the dedicated IP feature which is only $12 a month ... Wish I knew this was so easy earlier ... Thanks again! – hansolo May 02 '17 at 16:06

IP Address SQL Server

0 Answers0