Input server name/ IP: balmorel-db.database.windows.net
Use SQL-authentication: Select!
SQL User: [your username] (see list in image below)
Select Database: BalmorelCloud_ea_trainer (note that drop-down does not work, you have to copy paste the name)
Database name in workbook: [Name of own choice] (not required)
Press button “Test Connection” to ensure appropriate settings
Press button “Connect”
so when i finished and click “test connection” i got an error msg