Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Hands-On SQL Server 2019 Analysis Services

You're reading from   Hands-On SQL Server 2019 Analysis Services Design and query tabular and multi-dimensional models using Microsoft's SQL Server Analysis Services

Arrow left icon
Product type Paperback
Published in Oct 2020
Publisher Packt
ISBN-13 9781800204768
Length 474 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Steven Hughes Steven Hughes
Author Profile Icon Steven Hughes
Steven Hughes
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Preface 1. Section 1: Choosing Your Model
2. Chapter 1: Analysis Services in SQL Server 2019 FREE CHAPTER 3. Chapter 2: Choosing the SQL Server 2019 Analytic Model for Your BI Needs 4. Section 2: Building and Deploying a Multidimensional Model
5. Chapter 3: Preparing Your Data for Multidimensional Models 6. Chapter 4: Building a Multidimensional Cube in SSAS 2019 7. Chapter 5: Adding Measures and Calculations with MDX 8. Section 3: Building and Deploying Tabular Models
9. Chapter 6: Preparing Your Data for Tabular Models 10. Chapter 7: Building a Tabular Model in SSAS 2019 11. Chapter 8: Adding Measures and Calculations with DAX 12. Section 4: Exposing Insights while Visualizing Data from Your Models
13. Chapter 9: Exploring and Visualizing Your Data with Excel 14. Chapter 10: Creating Interactive Reports and Enhancing Your Models in Power BI 15. Section 5: Security, Administration, and Managing Your Models
16. Chapter 11: Securing Your SSAS Models 17. Chapter 12: Common Administration and Maintenance Tasks 18. Other Books You May Enjoy

Reviewing security settings for SSAS

SSAS builds on a rich history of security built into the platform with a focus on keeping vital business data secure. In this section, we will review the core security properties and their impact on your environment.

Opening the security settings for the server

While the core engine that runs each mode (multidimensional and tabular) is different, much of the management is shared. This means the properties can be found in the same location and modified in the same way. You will see that some types of properties only apply to one of the modes. However, for security settings, they are the same. But first, let's open our security settings so that we can review the impact:

  1. Open SSMS and connect to both instances of SSAS.
  2. Right-click on the name of the instance and select Properties, as shown in the following screenshot:

    Figure 11.1 – Server properties in the shortcut menu

    This will open the Analysis Services Properties dialog...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime