Solved

Excel to SQL Azure DB

Posted on 2014-11-27
3
248 Views
Last Modified: 2014-12-25
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
0
Comment
Question by:nutnut
3 Comments
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
ID: 40469693
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40517448
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now