i trying retrieve data azure sql database using azure data lake analytics following this guide. run u-sql job on azure data lake analytics , got following error:
failed connect data source: 'samplesource', error(s): 'cannot open server '' requested login. client ip address '25.66.9.211' not allowed access server. enable access, use windows azure management portal or run sp_set_firewall_rule on master database create firewall rule ip address or address range. may take 5 minutes change take effect.'
after running job couple of times, observed ip range needs added in server pretty wide. seems need add 25.66.xxx.xxx. have 2 questions:
- how can narrow range?
- why typical setting allows azure services access doesn't work?
at point have add full range (which internal ips). reason typical setting not working, machines needing access not managed in same way. working on having them added. data center database in?
Comments
Post a Comment