Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


VirtualKiwi

29 posts

Geek
+1 received by user: 7


#191488 5-Feb-2016 16:47
Send private message

I'm working on a desktop database app for a client where the data has been moved to SQL Azure SQL database.

 

They have some users who will be working from home, all of whom are Spark customers.

 

SQL Azure SQL database require firewall rules to explicitly allow IP addresses that can access the database.

 

Spark provides limited means of contact, and when I tried online support chat, I was told that they could not provide me with a list of IP address ranges they use.

 

I don't particularly want to have to be contacted to add each user's IP address and with dynamic IP addresses these could change.

 

Does anyone know of how to get hold of a list of Spark IP address ranges as used by domestic internet, IE ADSL,VDSL,fibre ?


Create new topic
hio77
'That VDSL Cat'
13036 posts

Uber Geek
+1 received by user: 3896

ID Verified
Trusted
Lizard Networks
Subscriber

  #1486085 5-Feb-2016 16:53
Send private message

have you considered instead of opening up the hole to whole ranges, Requiring a vpn connection?





#include <std_disclaimer>

 

Any comments made are personal opinion and do not reflect directly on the position my current or past employers may have. 




yitz
2238 posts

Uber Geek
+1 received by user: 594


  #1486093 5-Feb-2016 17:09
Send private message

Most if not all of their domestic broadband IP's originate within AS 4771.

 

http://bgp.he.net/AS4771 

 

But as above, depending on your requirements consider something more secure 


Talkiet
4819 posts

Uber Geek
+1 received by user: 3934

Trusted

  #1486149 5-Feb-2016 18:02
Send private message

yitz:

 

Most if not all of their domestic broadband IP's originate within AS 4771.

 

http://bgp.he.net/AS4771 

 

But as above, depending on your requirements consider something more secure 

 

 

 

 

All our residential BB customers (xDSL and Fibre) will be in AS4771. We do have ranges broken down further by access type and locality but we're not prepared to share those because of issues keeping those lists up to date. Changes are made and ranges move from time to time and we're not prepared to externally expose that level of detail.

 

 [edit - the list quoted above is a reasonable list to use - I'm talking about the access type and location breakdown we won't expose]

 

Cheers - N

 

 





Please note all comments are from my own brain and don't necessarily represent the position or opinions of my employer, previous employers, colleagues, friends or pets.


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.