I have created a simple Access 2013 database that is linked via ODBC to an Azure SQL server. Due to the limitations of Azure SQL (must declare IP addresses) and the security risks involved of opening the IP range to encompass all IP's, what is the simplest way to have the Access database talk to the Azure SQL server with unknown IP addresses without opening up all the IP's? I would like to keep this all in Azure if possible.
我创建了一个简单的Access 2013数据库,它通过ODBC链接到Azure SQL服务器。由于Azure SQL的限制(必须声明IP地址)以及打开IP范围以包含所有IP所涉及的安全风险,使Access数据库与具有未知IP地址的Azure SQL服务器通信而不打开的最简单方法是什么所有的IP?如果可能的话,我想将这一切保留在Azure中。
Is there a way to create a simple web layer in which the Access database will speak to, thus I only need to open the IP address for the web layer? If so, will I need to change how the Access database functions? There are some SQL functions that change the database directly when users change/add information...
有没有办法创建一个简单的Web层,Access数据库将与之对话,因此我只需要打开Web层的IP地址?如果是这样,我是否需要更改Access数据库的功能?当用户更改/添加信息时,有一些SQL函数可以直接更改数据库...
I have done a little research and it appears I must host my own web layer, but how could I set it up in Azure to work with the existing Access database?
我做了一些研究,似乎我必须拥有自己的Web层,但是如何在Azure中设置它以使用现有的Access数据库?
1 个解决方案
#1
The only way I can think of, is to have some kind of registration procedure for the potential user.
我能想到的唯一方法是为潜在用户提供某种注册程序。
When approved, log the calling IP address and run a script that adds this IP address to the pool of allowed IP adresses of your Azure database. This, I believe, can be done via an API call or a PowerShell script, though I have no idea of the details.
获得批准后,记录调用IP地址并运行一个脚本,将此IP地址添加到Azure数据库允许的IP地址池中。我相信,这可以通过API调用或PowerShell脚本完成,但我不知道细节。
#1
The only way I can think of, is to have some kind of registration procedure for the potential user.
我能想到的唯一方法是为潜在用户提供某种注册程序。
When approved, log the calling IP address and run a script that adds this IP address to the pool of allowed IP adresses of your Azure database. This, I believe, can be done via an API call or a PowerShell script, though I have no idea of the details.
获得批准后,记录调用IP地址并运行一个脚本,将此IP地址添加到Azure数据库允许的IP地址池中。我相信,这可以通过API调用或PowerShell脚本完成,但我不知道细节。