问题描述
不知道在主题行中输入什么内容,因此如果不清楚,表示歉意.
Ok not sure what to enter in the subject line so apologies if it stands unclear.
我使用MS Access 2013创建了一个简单的Web应用程序.它只包含一个带有示例数据的表.我将其启动到我的共享点.在继续之前,我想告诉您,我使用的是Office 365企业版,我们需要管理所有内容,例如Lync/SharePoint/Exchange等.
I created a simple web app using MS Access 2013. It simply had one table with sample data in it. The I launched it to my share point. Before we go ahead, I would like to tell you that I am using Office 365 enterprise version where we need to admin everything like Lync/SharePoint/Exchange etc.
因此,根据Microsoft博客,文章和讨论的全部内容,甚至以下屏幕截图也表明,存储在Office 365中的数据存储在用于Office 2013 Web应用程序的SQL Azure数据库中.
So as per Microsoft blogs and articles and discussions all over, and even the following screenshot suggests that the data stored in the Office 365 is stored in a SQL Azure database for office 2013 web app.
因此,下一步,网上说明说,如果我们选择从任何位置"并启用读写连接",它应允许您从任何窗口(如SQL Server管理窗口)访问数据.
So as the next step, the instructions over web says that if we choose "From Any Location" and enable "Read Write Connection", it should allow you to access the data from any window like SQL Server Management Window.
好吧,我的凭证如下:
现在,当我进入SQL Server Management Studio并使用上面的凭据并尝试登录时,出现以下错误:
Now, when I go to SQL Server Management Studio and use the above credential, and try to login, I get the following error:
我假设我们需要更改管理页面中的某些设置,以便可以进行连接.有什么帮助吗?我认为连接它似乎很简单,但是没有连接.
I am assuming that there is some setting in our admin page I need to change which can allow me to connect. Any help? I think it seems pretty straight forward to connect it but it is not connecting.
有帮助吗?
我们是否必须修复BCS之类的东西?请帮忙.
Do we have to fix anything like BCS? Please help.
我已经得到了2张赞成票,所以请注意,我已经尝试阅读50多个不同的网页来讨论此问题,但没有一个说完全有问题.无论他们提供什么解决方案,我都尝试过.为什么在不发表评论的情况下投票?有趣吗?
I have already got two downvotes so please note that I have tried reading more than 50 different web pages discussing this and none of it said it can be problem at all. Whatever solution they could offer, I have tried it. Why downvote without commenting? For fun eh?
谢谢,维卡斯B
推荐答案
在Sql Server Management Studio的连接服务器"对话框上,选择选项并插入要连接的数据库的名称
On connect server dialog at Sql Server Management Studio select options and insert the name of database that you want to connect
这篇关于连接到包含MS Access Web App后端的SQL Azure的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!