title: Connect to SQL Azure containing backend for MS Access Web App
body: <p>Ok not sure what to enter in the subject line so apologies if it stands unclear.</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p><img src="https://i.stack.imgur.com/03wTs.png" alt="What next"></p>
  
  <p>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.</p>
  
  <p><img src="https://i.stack.imgur.com/Y8uuw.png" alt="The Data Connectivity options"></p>
  
  <p>Ok, my credential looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/8TNV3.png" alt="Credentials: Oscillate Infotech Pvt Ltd DB"></p>
  
  <p>Now, when I go to SQL Server Management Studio and use the above credential, and try to login, I get the following error:</p>
  
  <p><img src="https://i.stack.imgur.com/DKOqU.png" alt="Oscillate Infotech Pvt Ltd: Error"></p>
  
  <p>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.</p>
  
  <p>Any help?</p>
  
  <p>Do we have to fix anything like BCS? Please help.</p>
  
  <p>Edit: 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?</p>
  
  <p>Thanks,
  Vikas B</p>