Solved

Excel to SQL Azure DB

Posted on 2014-11-27
3
261 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 47

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

710 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