Connect to Azure SQL Database

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
in Platform

Hello all,

 

Has anyone tried connecting an on-premise Board instance to a SQL database in Azure? Can't seem to find any available connectors for it.

 

 

TIA

 

Michael 

Answers

  • Previous Member
    Previous Member
    5 Up Votes First Comment 5 Likes First Anniversary
    Options

    Hi,

    Where are you looking for connectors exactly ? Could you provide a screenshot of where you are looking ?

  • Previous Member
    Previous Member
    5 Up Votes First Comment 5 Likes First Anniversary
    edited March 2020
    Options

    From my experience, i didn't succeeded using a windows ODBC connector set on the BOARD server, so I used the connection string available in MS Azure directly:

    image

     

    Unfortunately, BOARD doesn't allow to select and copy the connection string within the data reader connection parameters window.

    The string I have is:

    Driver={ODBC Driver 13 for SQL Server};Server=tcp:myDBserver.database.windows.net,1433;Database=MyDatabase;Uid=MySQLuser@MyDatabase;Pwd=MyPassword;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

     

    You should find this string available in your Microsoft Azure SQL Database interface, which looks like this in my case:

    image

     

    I hope this helps.

Categories