MS Access FE connecting to Azure SQL Server from anywhere (any IP)


1 comment

  • Avatar
    Rachel Gomez

    To connect to Azure SQL Database:

    On the File menu, select Connect to SQL Azure (this option is enabled after the creation of a project). If you previously connected to Azure SQL Database, the command name will be Reconnect to SQL Azure.

    In the connection dialog box, enter or select the server name of Azure SQL Database.

    Enter, select, or Browse the Database name.

    Enter or select Username.

    Enter the Password.

    SSMA recommends encrypted connection to Azure SQL Database.

    Click Connect.

    If there are no databases in the Azure SQL Database, you can create the first database using Create Azure Database option that appears on the click of Browse button.




    Comment actions Permalink

Please sign in to leave a comment.