Excel to SQL Azure DB

Hi,

We have an excel workbook that refreshes with data from SQL Server.

We want to set up a SQL Azure DB, repoint the Excel connection to the new SQL Azure DB and refresh excel from Azure.  This is all done in a Fixed IP location.

So far no problem....

BUT

What if the user of the excel workbook is on a laptop and the laptop is now not in the office it is now on a dynamic Ip address.  What is the best way of getting this to work without adding the dynamic IP each time or adding a 0.0.0.0 to 255.255.255.255 range?

Can we host on Azure SharePoint as a go between...any third party apps etc.

Thanks
nutnutAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions ConsultantCommented:
You could create or pay for a VPN to provide a static IP.

Creating your own VPN would be the best option since it would provide benefits above and beyond providing access to the database.
http://www.pcworld.com/article/2030763/how-and-why-to-set-up-a-vpn-today.html

Other options could include
Ask your Internet Service Provider (ISP) for the IP address range assigned to your client computers that will access the SQL Database server - NOTE: THIS IS NOT SECURE and I would NOT recommend it.

Get static IP addressing instead for your client computers, and then add the IP addresses as SQL Database firewall rules. Your ISP may not support this especially on Mobile data
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Azure

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.