Security Considerations with SQL Azure and PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

In this former blog post I discussed how to enable access to SQL Azure from PowerPivot. Now that access is enabled and the data is available to you, let’s examine how PowerPivot and SQL Azure work from a security perspective.

Accessing the Data

In order to use PowerPivot against your SQL Azure data you need to download the data into the Excel workbook. How to enable the user access to the SQL Azure firewall, and create a user account in SQL Azure for accessing the data is covered in this earlier blog post.

Read more...

 

Tags: excel, azure, security

 

2007-2015 VidasSoft Systems Inc.