Can't view SQL database tables in Data Connection Wizard

[majorlou]

Hello

We have a SQL database in Azure setup but we can't connect to the tables in Excel 2007.

We're selecting Data, From Other Sources, then From SQL Server and enter the server address / port alongside the relevant username and password.

We can see the database "HS" in the database selection dropdown, but no tables show for selection underneath (see image).

When we try the same method in Excel 2016 on a virtual machine we don't have any problems.

Can anyone help or advise why we can't see the database tables to connect to?

Thanks
Adam