To query the database, start Excel, go to the Tools menu and ... It will now ask for the authentication method. Select SQL-Server Authentication and enter the Login Id as “sa”.

An add-in for Excel, PowerPivot is built on the SQL Server Analysis Service Engine ... And for those who don't want to deal with a separate authentication method, PowerPivot workbooks uses ...

Instead of just importing static snapshots of your database information into Excel, SaveToDB allows you to directly connect to live databases like SQL Server, Oracle, MySQL, and many more.

as used in Azure SQL Database, Microsoft's free SQL Server Data Tools (which can be downloaded here) will be used instead. The improved authentication added to Azure SQL Data Warehouse is an ...