none
Connecting SQL Via BCS RRS feed

  • Question

  • Twitter customer @nholloway4 is experiencing the following problem:

    "Hello, I need some assistance with connecting to SQL Azure via BCS. Created SSA ID and used appropriately. It prompts me to enter credentials so I enter "username@domain.onmicrosoft.com" for the username and the password for my office365 account and received error about it not being correct format, Any help?"

    This login produces the following error message:

    Thank you!

    @AzureSupport

    Wednesday, September 23, 2015 9:23 PM

Answers

  • This scenario is not supported yet. The Azure AD authentication for Azure SQL DB (a new feature currently in public preview; search for "Connecting to SQL Database By Using Azure Active Directory Authentication") is not integrated with BCS (no timeline yet). In addition Azure AD auth currently does not support Microsoft accounts (see the above link).
    Mirek
    Mirek Sztajno Senior PM, Azure SQL DB

    Thursday, September 24, 2015 5:14 PM

All replies

  • This scenario is not supported yet. The Azure AD authentication for Azure SQL DB (a new feature currently in public preview; search for "Connecting to SQL Database By Using Azure Active Directory Authentication") is not integrated with BCS (no timeline yet). In addition Azure AD auth currently does not support Microsoft accounts (see the above link).
    Mirek
    Mirek Sztajno Senior PM, Azure SQL DB

    Thursday, September 24, 2015 5:14 PM
  • It has worked before, so why is this occurring now. Otherwise I would have not been able to connect to my SQL Azure DB.
    Sunday, September 27, 2015 9:38 PM
  • Casey

    Why doesn't this solution which worked previously work for me now

    http://social.technet.microsoft.com/wiki/contents/articles/28286.office-365-sharepoint-online-bcs-with-azure-sql-server-database.aspx

    Friday, October 9, 2015 5:57 PM